Category Archives: T-SQL

New Post on SQL Authority

Over the past year, Linchpin People consultants have contributed to Pinal Dave’s popular SQL Authority site in the Notes From the Field¬†series. Since I am new to Linchpin People, I just got in the rotation and contributed the 52nd installment. … Continue reading

Posted in T-SQL | Leave a comment

Is ROW_NUMBER() non-deterministic?

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?

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