SentryOne Team Blog (blogs.sentryone.com)

Tag : aggregates

Paul White : Grouped Aggregate Pushdown

Paul White : Grouped Aggregate Pushdown

Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.

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.