Expert T-SQL Window Functions in SQL Server 2019 The Hidden Secret to Fast Analytic and Reporting Queries /

• Main Authors: Kellenberger, Kathi (Author, http://id.loc.gov/vocabulary/relators/aut), Groom, Clayton (http://id.loc.gov/vocabulary/relators/aut), Pollack, Ed (http://id.loc.gov/vocabulary/relators/aut)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Berkeley, CA : Apress : Imprint: Apress, 2019.
• Edition: 2nd ed. 2019.
• Subjects: Database management.; Programming languages (Electronic computers).; Microsoft software.; Microsoft .NET Framework.; Database Management.; Programming Languages, Compilers, Interpreters.; Microsoft and .NET.

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

Table of Contents:

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