Continuation from the previous 17 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This time lets see which improvements were delivered for the Batch Mode processing for the SQL Server 2014 CTP1. Batch Mode query execution was introduced in SQL Server 2012 specifically for…

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…

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…

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…

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…