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.
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.