Optimization Thresholds – Grouping and Aggregating Data, Part 1 In his first SQLPerformance post, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator. Itzik Ben-Gan ◆ April 10, 2018 6
Maintaining a grouped running MAX (or MIN) SQL Sentry's Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query. Aaron Bertrand ◆ October 8, 2015 0