Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)

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”)

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…