Azure SQLDatabase

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

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

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 enterprise option for the Clustered Columnstore Indexes and one of the most long-awaited one…

Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”)

Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”)

Continuation from the previous 120 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Yesterday, Kevin Farlee (Program Manager for Columnstore Indexes) announced that Columnstore Indexes have finally found their way into Standard Tier of the Azure SQL Database, I…

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/. As a logical continuation from the blog post Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”), this blogpost will focus on the SQL…

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…