Clustered Columnstore Indexes – part 42 (“Materialisation”)

Clustered Columnstore Indexes – part 42 (“Materialisation”)

Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Important Disclaimer – I have started writing this blog post over 1 months ago, but because of all engagements such as SQLSaturday Portugal, only today at night managed to finally finish…

Clustered Columnstore Indexes – part 41 (“Statistics”)

Clustered Columnstore Indexes – part 41 (“Statistics”)

Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Note: This article is in’s 2nd version, after correcting comments done by Hugo Kornelis Since I have started writing & doing presentations on Columnstore Indexes there have been a number of…

Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)

Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)

Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ It’s time to take a look into the algorithms that Microsoft is using to compress Columnstore Indexes. I have presenting on this topic for quite some time and especially during Workshops…