Continuation from the previous 123 parts, the whole series can be found at https://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”)
[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 https://www.nikoport.com/columnstore/. I am finally ready to write about one of the most important…
Columnstore Indexes – part 122 (“Wait Types”)
Continuation from the previous 121 parts, the whole series can be found at https://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…
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 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…