Clustered Columnstore Indexes – part 50 (“Columnstore IO”)

Clustered Columnstore Indexes – part 50 (“Columnstore IO”)

Continuation from the previous 49 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blogpost is focused on the reading part of the IO subsystem of the Columnstore Indexes. I will try to explain the improvements in the reading process as well as some…

Clustered Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”)

Clustered Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”)

Continuation from the previous 48 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Note: Updated on 05th of March 2015 with information on SQL Server 2012. Having blogged a couple of times on the matters of Segment Elimination (“Data Loading for Better Segment Elimination”,…

Clustered Columnstore Indexes – part 48 (“Improving Dictionary Pressure”)

Clustered Columnstore Indexes – part 48 (“Improving Dictionary Pressure”)

Continuation from the previous 47 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to one of the most complex problems in Columnstore Indexes – the Internal Pressure within the Columnstore Dictionaries, that makes Row Groups being cut off with number…

Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)

Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)

Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is a continuation from the the post 44, where I have listed different Extended Events. In this post I will go into practical examples with detailed explanations on how…