Bücher online kaufen
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.
Hauptbeschreibung
Helps you write better performing queries using window functions
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:
9781484251966
Veröffentl:
2019
Erscheinungsdatum:
22.10.2019
Seiten:
232
Autor:
Kathi Kellenberger
Gewicht:
445 g
Format:
254x178x13 mm
Sprache:
Englisch
58,84 €*
Lieferzeit: Print on Demand - Lieferbar innerhalb von 3-5 Werktageni
Alle Preise inkl. MwSt.
| zzgl. Versand