Langbeschreibung
Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.
Hauptbeschreibung
Helps you write better performing queries using window functions
Inhaltsverzeichnis
1. Looking through the Window.- 2. Discovering Ranking Functions.-3. Summarizing with Window Aggregates.- 4. Calculating Running and Moving Aggregates.- 5. Adding Frames to the Window.- 6. Taking a Peek at Another Row.- 7. Understanding Statistical Functions.- 8. Tuning for Better Performance.- 9. Hitting a Home Run with Gaps, Islands, and Streaks.- 10. Time Range Calculations.- 11. Time Trend Calculations.