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

Author:   Kathi Kellenberger ,  Clayton Groom ,  Ed Pollack
Publisher:   APress
Edition:   2nd ed.
ISBN:  

9781484251966


Pages:   213
Publication Date:   22 October 2019
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $49.99 Quantity:  
Add to Cart

Share |

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


Add your own review!

Overview

Full Product Details

Author:   Kathi Kellenberger ,  Clayton Groom ,  Ed Pollack
Publisher:   APress
Imprint:   APress
Edition:   2nd ed.
Weight:   0.454kg
ISBN:  

9781484251966


ISBN 10:   1484251962
Pages:   213
Publication Date:   22 October 2019
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

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

Reviews

Author Information

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. Clayton Groom is a data warehouse and analytics consultant at Clayton Groom, LLC. He has worked with SQL Server for 25 years. His expertise lies in designing and building data warehouse and analytic solutions on the Microsoft technology stack, including Power BI, SQL Server, Analysis Services, Reporting Services and Excel. Edward Pollack has over 20 years of experience in database and systems administration and architecture, developing a passion for performance optimization and making things go faster. He has spoken at many SQL Saturdays, 24 Hours of PASS, and PASS Summits, and has coordinated SQL Saturday Albany since its inception in 2014.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

wl

Shopping Cart
Your cart is empty
Shopping cart
Mailing List