Continuation from the previous 115 parts, the whole series can be found at https://www.nikoport.com/columnstore/ After delaying for a couple of years (yes, strangely there is other priority in my life, besides this blog post series) – I am finally putting…
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list…
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post will talk about some of the common problematic practices for the Columnstore Indexes and how to avoid or solve them. It is not…
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…