Category Archives: T-SQL

Slides from Data Platform Discovery Day and finding the limits of a WHERE clause

Yesterday, I was privileged to speak at the first Data Platform Discovery Day. This event was virtual and the brainchild of Data Platform MVP Matt Gordon (@sqlatspeed) with one day in US time zones and one for Europe. He realized … Continue reading

Posted in T-SQL | Leave a comment

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