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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Kellenberger, Kathi (Autor), Groom, Clayton (Autor), Pollack, Ed (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : Apress, [2019]
Edición:Second edition.
Temas:
SQL server.
SQL server
SQL (Computer program language)
SQL (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares