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…

Clustered Columnstore Indexes – part 46 (“DateTime compression and performance”)

Clustered Columnstore Indexes – part 46 (“DateTime compression and performance”)

Continuation from the previous 45 parts, starting from http://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…