Clayton Groom

发表

Expert T-SQL Window Functions in SQL Server

Kathi Kellenberger, Clayton Groom, 2015, Apress.

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

Kathi Kellenberger, Clayton Groom, Ed Pollack, 2019 .

Adding Frames to the Window

Kathi Kellenberger, Clayton Groom, 2015 .

Time Range Calculations

Kathi Kellenberger, Clayton Groom, Ed Pollack, 2019 .

Understanding Statistical Functions

Kathi Kellenberger, Clayton Groom, 2015 .

Calculating Running and Moving Aggregates

Kathi Kellenberger, Clayton Groom, 2015 .

Looking Through the Window

Kathi Kellenberger, Clayton Groom, 2015 .

Tuning for Better Performance

Kathi Kellenberger, Clayton Groom, 2015 .

Hitting a Home Run with Gaps, Islands, and Streaks

Kathi Kellenberger, Clayton Groom, Ed Pollack, 2019 .

Time Trend Calculations

Kathi Kellenberger, Clayton Groom, Ed Pollack, 2019 .

Taking a Peek at Another Row

Kathi Kellenberger, Clayton Groom, 2015 .

Time Range Calculations and Trends

Kathi Kellenberger, Clayton Groom, 2015 .

Summarizing with Window Aggregates

Kathi Kellenberger, Clayton Groom, 2015 .