Continuation from the previous 27 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is all about the architectural specifics & performance optimizations for the Clustered Columnstore Indexes. It is known that Inserts are mostly faster than pure Update operations, since we…
Continuation from the previous 26 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Let us consider a situation when we are using so-called Trickle Loads into Delta-Stores of a Clustered Columnstore Index. Naturally, this is a not very much desired situation, since the best…
I am extremely happy to be selected as a speaker for the very first Business Intelligence Edition of SQLSaturday in Europe, in Edinburgh (Scotland), which will happen on 14th of June 2014. Organised by European PASS Director Jen Stirrup, this…
This is my all time first post on the matter of PowerQuery, even though I have been playing and presenting it since it was publicly available almost a year ago (March 2013). First of all I have to recognise Andreas…
Continuation from the previous 25 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This time I decided to take a look at how having Columnstore Indexes in a database is affecting database backup & restore procedures. I decided to take a simple backup from…