Clustered ColumnStore Index Archives

T-SQL Tuesday Retrospective #011: Misconceptions

by Randolph
March 10, 2021September 16, 2022

(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when it comes to SQL Server: The… T-SQL Tuesday Retrospective #011: Misconceptions

A trillion and one

by Randolph
September 13, 2017September 12, 2017

Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in SQL Server, using a clustered columnstore index to maximise the compression. (Short version: it’s very… A trillion and one