Bücher online kaufen
|
| Der Artikel wird am Ende des Bestellprozesses zum Download zur Verfügung gestellt. |
Expert T-SQL Window Functions in SQL Server 2019
The Hidden Secret to Fast Analytic and Reporting Queries
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.
Kathi Kellenberger is a data platform MVP and the editor of Simple-Talk at Redgate Software. She has worked with SQL Server for over 20 years. She is also co-leader of the PASS Women in Technology Virtual Group and an instructor at LaunchCode. In her spare time, Kathi enjoys spending time with family and friends, singing, and cycling.
ISBN-13:
9781484251973
Veröffentl:
2019
Seiten:
213
Autor:
Kathi Kellenberger
eBook Typ:
PDF
eBook Format:
EPUB
Kopierschutz:
1 - PDF Watermark
Sprache:
Englisch
56,99 €*
Lieferzeit: Sofort lieferbar
Alle Preise inkl. MwSt.