Clustered column stores are a great feature that if used correctly can save a lot of space and increase the performance of your reporting and analytical queries. But it needs to be designed and configured correctly and the data needs to be loaded in a certain way to make it effective. This session will demonstrate how to partition, model, select data types, insert data into a clustered column store, and write queries to get the data out as efficiently and quickly as possible.

It will also tell you what you, unfortunately, can not (or should not) do with a clustered column store index.


Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 10 years and has spoken regularly at conferences, SQL Saturdays, and user groups for 13 years.