Search Results

Columnstore Indexes – part 116 (“Partitioning Specifics”)

Continuation from the previous 115 parts, the whole series can be found at http://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 94 (“Use Partitioning Wisely”)

Continuation from the previous 93 parts, the whole series can be found at http://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 http://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 http://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…