Columnstore Blog Post

Columnstore Indexes – part 129 (“Compatibility with the New Features of Sql Server 2019”)

Columnstore Indexes – part 129 (“Compatibility with the New Features of Sql Server 2019”)

Continuation from the previous 128 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In this blog post I would like to point the compatibilities with the immediately upcoming release of Sql Server 2019 and the Columnstore Indexes. In the…

Columnstore Indexes – part 128 (“Ordering Columnstore Indexes in Azure SQL Datawarehouse”)

Columnstore Indexes – part 128 (“Ordering Columnstore Indexes in Azure SQL Datawarehouse”)

Continuation from the previous 127 parts, the whole series can be found at http://www.nikoport.com/columnstore/. First of all and before everything else, I would like to extend my gratitude to Xiaoyu Li (Microsoft PM) for taking her time and exchanging long…

Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)

Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)

Continuation from the previous 126 parts, the whole series can be found at http://www.nikoport.com/columnstore/. With the appearance of the Batch Mode on the Rowstore Indexes (FINALLY!), the big question (aka Elefant) is in the room – DO WE STILL NEED…

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…