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…

Clustered Columnstore Indexes – part 39 (“Memory in Action”)

Clustered Columnstore Indexes – part 39 (“Memory in Action”)

Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In this post I shall try to discover more interesting information about Columnstore Object Pool behaviour and it’s relations to the total size of the available memory as well as the…

Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ In the past I have been writing quite a lot on the matter of the Columnstore structures and their performance, and so it’s definitely time to make some explanations of what…