-
Recent Posts
- Update from Nikita 2025/04/09
- Help requested for a friend of PASS Summit 2024/11/19
- Registration is open for PASS Data Community Summit! 2022/04/05
- Intelligent Query Processing Session Follow Up 2020/11/16
- Move a VM with Azure Resource Mover 2020/09/24
Categories
- Cloud computing (1)
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (33)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (8)
- T-SQL (12)
- T-SQL Window Functions (12)
- Uncategorized (27)


Author Archives: Kathi Kellenberger
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
