-
Recent Posts
- Configuring SQL Monitor 2018/01/04
- My First Look at SQL Monitor 2017/12/19
- Live from Cambridge! 2017/12/07
- PASS Summit 2017 Report 2017/11/05
- What’s Next for Aunt Kathi? 2017/10/05
Categories
- Database Administration (6)
- High Availability (1)
- Internals (1)
- Life in IT (25)
- Security (1)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (6)
- T-SQL (10)
- T-SQL Window Functions (11)
- Uncategorized (20)
Category Archives: T-SQL Window Functions
T-SQL Puzzler
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?
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!
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