Category Archives: T-SQL

T-SQL Puzzler

UPDATE: I have included an alternate solution from one of my readers! I have presented on T-SQL Window Functions at least 30 times over the past five years. I love the comments I get after the presentations. Without fail, at … Continue reading

Posted in T-SQL, T-SQL Window Functions | 2 Comments

What is a Partitioned View?

Back when I first began working with SQL Server in 1998, the databases I worked with could be measured in megabytes. I remember being a bit concerned when a database for one of my customers approached 1 GB. In today’s … Continue reading

Posted in T-SQL, T-SQL Window Functions | 1 Comment

Code and Slides for Nebraska.Code() Conference

Thursday at Nebraska.Code() Conference, I taught a workshop on T-SQL Query tuning. It was a great afternoon. Here are the files. I also presented my T-SQL Window Function session on Friday afternoon. Files for that presentation are here.

Posted in T-SQL, T-SQL Window Functions | 5 Comments