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

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
Autores principales: Kellenberger, Kathi. author (author), Groom, Clayton. author, Pollack, Ed. author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2019.
Edición:2nd ed. 2019.
Materias:
SQL server.
Database management.
Programming languages (Electronic computers).
Microsoft software.
Microsoft .NET Framework.
Database Management.
Programming Languages, Compilers, Interpreters.
Microsoft and .NET.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630783106719
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