Category Archives: T-SQL Window Functions

T-SQL Puzzler

Posted on 2017/02/20 by

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?

Posted on 2015/08/26 by

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

New Book on T-SQL Window Functions!

Posted on 2015/03/21 by

I am very pleased to announce that my new book “Expert T-SQL Window Functions in SQL Server” is now available! This book covers everything I talk about in my two window function presentations plus even more material. I am also thrilled … Continue reading →

Posted in T-SQL Window Functions | 13 Comments