Category Archives: T-SQL

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 →

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.

My favorite T-SQL windowing functions are LAG and LEAD. LAG and LEAD let you take a peek at another row and grab any column you need in your results. They are easy to use and perform great…except when they don’t. … Continue reading →