Continuation from the previous 16 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Lets compare to check if there were any improvements between the handling of the memory for Columnstore Indexes between SQL Server 2012 & upcoming SQL Server 2014. I will be keep…
Clustered Columnstore Indexes – part 16 (“Index Builds”)
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 13 (“Dictionaries Analyzed”)
Continuation from the previous 12 parts, starting from https://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…