Continuation from the previous 48 parts, starting from https://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”,…
Continuation from the previous 47 parts, starting from https://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…
Continuation from the previous 46 parts, starting from https://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…
The SQLBits conference has a special place in my heart – as I have written before, the previous edition of SQLBits was the best conference I have ever attended. I have already publicly declared that I would attend it no…
Continuation from the previous 45 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ At the last SQLPort event in December 2014, I have listened to a presentation by Alberto Ferrari talking about DAX and giving some tuning advices regarding the Date Dimensions in xVelocity…