business intelligence

Columnstore Indexes – part 69 (“Operational Analytics – Disk Based”)

Columnstore Indexes – part 69 (“Operational Analytics – Disk Based”)

Continuation from the previous 68 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost is dedicated to one of the key improvements in Columnstore Indexes in SQL Server 2016 – the Operational Analytics. This blog post is focused…

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…