Expert T-SQL window functions in SQL Server 2019 : the hidden secret to fast analytic and reporting queries /

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

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Authors: Kellenberger, Kathi (Author), Groom, Clayton (Author), Pollack, Ed (Author)
Format: Electronic eBook
Language:Inglés
Published: New York : Apress, [2019]
Edition:Second edition.
Subjects:
SQL server.
SQL server
SQL (Computer program language)
SQL (Langage de programmation)
Online Access:Texto completo (Requiere registro previo con correo institucional)
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.

Similar Items