Tag : grouping - SentryOne Team Blog

Tag: grouping

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

For his first post on SQLPerformance.com, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.

Maintaining a grouped running MAX (or MIN)

Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.