Category Archives: T-SQL Window Functions

How to Use a Window Aggregate in an Aggregate Query

Posted on 2014/09/23 by Kathi Kellenberger

A window aggregate function is an easy way to perform an aggregate calculation without changing the query to an aggregate query. This means that you can calculate an aggregate over the entire dataset while keeping the detail in the results. … Continue reading →

Posted in T-SQL, T-SQL Window Functions | Leave a comment

Using Distinct with Window Aggregates

Posted on 2014/05/07 by Kathi Kellenberger

This past Saturday I presented my T-SQL Window Function Performance session at the Atlanta SQL Saturday. There were some interesting questions from the audience that didn’t actually pertain to performance. I didn’t have all the answers since there were some questions … Continue reading →

Posted in T-SQL Window Functions | Leave a comment

What is a Windowing Function?

Posted on 2014/03/25 by Kathi Kellenberger

I have been presenting and writing about windowing functions for a couple of years. I am always surprised that many people who don’t know what these are may already be writing queries using them. Every time I present on this … Continue reading →

Posted in T-SQL Window Functions | 1 Comment