Aaron Bertrand continues his series on large table compression with results from row and page compression, and a process involving scheduler manipulation.
Category: ColumnStore
Aaron Bertrand continues his series on investigating compression a 1TB table, honing in on clustered columnstore and partitioning.
Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
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.
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.
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.
