Continuation from the previous 130 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost will be about older SQL Server versions (2016, 2017) and some implications that I have found that people rather do not understand, until they…
Continuation from the previous 129 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Almost 2 years ago (22nd of March 2018) in Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DBâ€) I have already…
Continuation from the previous 128 parts, the whole series can be found at https://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…
Continuation from the previous 127 parts, the whole series can be found at https://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…
Continuation from the previous 126 parts, the whole series can be found at https://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…