Continuation from the previous 120 parts, the whole series can be found at https://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 120 (“Merge Replication 2016-2017”)
Continuation from the previous 119 parts, the whole series can be found at https://www.nikoport.com/columnstore/. A couple of days ago at the SQLKonferenz, during my full-day precon I have recieved a question that I could not answer for sure, because I…
Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)
Continuation from the previous 118 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This is a rather simple blog post that is dedicated to the theme of the In-Memory Columnstore Indexes location. This has been a constant topic of…
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at https://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”)
Continuation from the previous 116 parts, the whole series can be found at https://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…