Columnstore Blog Post

Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)

Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)

Continuation from the previous 125 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have a huge love for the DBCC CLONEDATABASE command – it has been made available (backported) to every SQL Server version starting with SQL Server…

Columnstore Indexes – part 125 (“Estimate Columnstore Compression as a System Stored Proc”)

Columnstore Indexes – part 125 (“Estimate Columnstore Compression as a System Stored Proc”)

Continuation from the previous 124 parts, the whole series can be found at http://www.nikoport.com/columnstore/. It is quite emblematic that this blog post is following the number 124 in the series – Columnstore Indexes – part 124 (“Estimate Columnstore Compression”), because…

Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)

Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)

Continuation from the previous 123 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For anyone working with SQL Server since version 2005 (with Service Pack 2 to be precise) there is a very common task when thinking or research…

Columnstore Indexes – part 123 (“Clustered Columnstore Index Online Rebuild”)

Columnstore Indexes – part 123 (“Clustered Columnstore Index Online Rebuild”)

[Updated VERY SIGNIFICANTLY on 9th of October 2018 after SQL Server 2019 CTP 2.0] Continuation from the previous 122 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I am finally ready to write about one of the most important…

Columnstore Indexes – part 122 (“Wait Types”)

Columnstore Indexes – part 122 (“Wait Types”)

Continuation from the previous 121 parts, the whole series can be found at http://www.nikoport.com/columnstore/. First of all, I would love to express deep gratitude to Vassilis Papadimos (Software Engineer @ Microsoft) and Joe Sack (Principal Program Manager @ Microsoft) for…