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…
Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1 – The initial preview offering. If you are interested in all the articles, feel free to visit my whole Columnstore…