Clustered Columnstore Indexes – part 13 (“Dictionaries Analyzed”)

Continuation from the previous 12 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This time I decided to play a little bit more with Clustered Columnstore dictionaries in order to understand them a little bit better. Continuing working with Contoso BI Database but this…

Clustered Columnstore Indexes – part 12 (“Compression Dive”)

Continuation from the previous 11 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In the previous blog posts of this series on Clustered Columnstore Indexes, we have created some Clustered Columnstore Indexes and NonClustered Columnstore Indexes, we have compared different type of compressions and…

Clustered Columnstore Indexes – part 11 (“Clustered vs Nonclustered compression basics”)

Continuation from the previous 10 parts, starting from http://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…

Clustered Columnstore Indexes – part 10 (“Compression basics”)

Continuation from the previous 9 parts, starting from http://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…

Clustered Columnstore Indexes – part 9 (“SQL Server 2014 CTP1 Observations”)

Continuation from the previous 8 parts, starting from http://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…