Clusters 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 do be designed, configured correctly and the data needs to be loaded in a certain way to make if effective. This session will demonstrate how to partition, model, select data types and insert data into a clustered column store and how to write queries to get the data out es efficient and quickly as possible.
It will also tell you all the things you unfortunately can not (or should not) do with a clustered column store index.
level: 300