Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)

Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)

Continuation from the previous 67 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focusing on some of the important details of loading data into Columnstore Indexes and the things that have changed in SQL Server…

Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Continuation from the previous 66 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Continuing from the last couple of blog posts on the improvements for the DataWarehouse scenario with Clustered Columnstore Indexes, I want to turn this time to…