-
Recent Posts
- 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
- Build Your Brand Presentation 2020/08/18
- Azure Data Studio Notebooks and SQL Prompt 2020/06/04
Categories
- Cloud computing (1)
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (32)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (8)
- T-SQL (12)
- T-SQL Window Functions (12)
- Uncategorized (26)
Category Archives: T-SQL Window Functions
Quick T-SQL Window Function Articles
Even after six years, I am still presenting at user groups and SQL Saturdays on T-SQL windowing functions. I have found that many data professionals haven’t heard about these great functions. Lots of folks are using ROW_NUMBER, but most haven’t … Continue reading
Posted in T-SQL Window Functions
Leave a comment
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