There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones. There is a technological event that is called SQLBits. It’s 12th edition last weekend was a different one. For me it was…
SQLBits XII Recap
Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)
Continuation from the previous 34 parts, starting from https://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/ This blog post is about controlling some of the Columnstore Indexes behaviours in less obvious ways – by using Trace Flags & Query Optimiser Rules. I will be looking into updating…
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Segment Elimination for Deleted Row Groups After some very interesting and inspiring conversations during SQLBits, I came to an idea of testing a Segment Elimination while working with a fully deleted…
Clustered Columnstore Indexes – part 33 (“Tuple Mover that closes open Delta-Stores”)
Continuation from the previous 32 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ We all love and use Columnstore Segments, but we all kind of scared of the open Delta-Stores (yes there can be more than 1). Why would that be? – because they…
SQLSaturday Rheinland 2014 Recap
Important disclaimer: I am closely associated with Tillmann Eitelberg & Oliver Engels since I am working with them at OH22. I am one of the luckiest guy of having attended & presented at every single SQLSaturday in Germany and this…