SentryOne Team Blog (blogs.sentryone.com)

Tag : ColumnStore

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.

Overview of Columnstore Indexes in SQL Server

Overview of Columnstore Indexes in SQL Server

Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.