Continuation from the previous 10 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is all about the the difference in the compression algorithms between Clustered Columnstore and Nonclustered Columnstore Indexes. As in the previous post, I have decided to continue using Contoso…

Continuation from the previous 9 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Now it is time to see the actual compression in action, and so for the beginnings I have downloaded Contoso BI database. This is a good enough database to start playing…

Continuation from the previous 8 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ I have been playing with the internals of the master database of the SQL Server 2014 CTP1 and hence have discovered a couple of interesting things: – While Replication will not…

Continuation from the previous 7 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In this part we shall play with Locking :) Lets setup our table with all defaults and with a Clustered Columnstore Index: IF OBJECT_ID(‘dbo.CCTest’, ‘U’) IS NOT NULL drop table dbo.CCTest;…

Continuation from the previous 6 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In this part we shall be dedicating to the Transactional support for Clustered Columnstore Indexes: Isolation Levels: As I have already mentioned in part 2, Isolation support for Clustered Columnstore Indexes…