01 How Columnstore Data is Stored

In How to Think Like the Engine, I used pieces of paper to explain how clustered and nonclustered rowstore indexes work. Columnstore is different, though. You may have heard that columnstore is like an index on every column, but it’s much more complex than that: it’s really a partitioned index on every column. We’ll take…