Category: ColumnStore

Aaron Bertrand continues his series on investigating compression a 1TB table, honing in on clustered columnstore and partitioning.
January 7, 2020 | SQLPerformance.com | SQL Server, ColumnStore 0
Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
December 27, 2019 | SQLPerformance.com | ColumnStore 0
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.
April 23, 2019 | SQLPerformance.com | SQL Server, ColumnStore 0
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.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More