Category Archives: T-SQL Window Functions

Quick T-SQL Window Function Articles

Even after six years, I am still presenting at user groups and SQL Saturdays on T-SQL windowing functions. I have found that many data professionals haven’t heard about these great functions. Lots of folks are using ROW_NUMBER, but most haven’t … Continue reading

Posted in T-SQL Window Functions | 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