Category Archives: T-SQL Window Functions

Files for my PASS Summit Windowing Function Session

Posted on 2014/11/10 by Kathi Kellenberger

Thanks to those of you who attended my session. As promised, I am sharing the slides and code.

Posted in T-SQL Window Functions | 1 Comment

Is ROW_NUMBER() non-deterministic?

Posted on 2014/10/05 by Kathi Kellenberger

I have presented my T-SQL Window function presentations for a couple of years. I love it when interesting questions come up during the session. Recently, during my intro session, I was showing the difference between ROW_NUMBER, RANK, and DENSE_RANK by … Continue reading →

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

What is the Difference between ROWS and RANGE?

Posted on 2014/09/27 by Kathi Kellenberger

UPDATE: For more from me about T-SQL Window Functions, check out my Pluralsight course! I have been speaking and writing a bunch lately on T-SQL window functions. There is always more to learn, it seems. Framing for many of the … Continue reading →

Posted in T-SQL, T-SQL Window Functions | 3 Comments