Continuation from the previous 15 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post will be dedicated to the process of building Clustered Columnstore Indexes. I will be keep on playing with the Contoso BI database. I have already mentioned in one of…
Clustered Columnstore Indexes – part 15 (“Partitioning Advanced”)
Continuation from the previous 14 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This specific post is a direct continuation of the previous one from the part 14, so the database at the moment should have the FactOnlineSales table already partitioned. Lets see what…
Clustered Columnstore Indexes – part 14 (“Partitioning”)
Continuation from the previous 13 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Lets play with partitioning this time! Get the Contoso BI Database, plug it in and lets start playing! :) We will be working with the FactOnlineSales table – first we need…
Clustered Columnstore Indexes – part 12 (“Compression Dive”)
Continuation from the previous 11 parts, starting from https://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 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…