Columnstore Blog Post

Columnstore Indexes – part 70 (“Filtered Indexes in Action”)

Columnstore Indexes – part 70 (“Filtered Indexes in Action”)

Continuation from the previous 69 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is the continuation from the previous one, where I have described the Operational Analytics for Rowstore. I have tried to create a filtered…

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…

Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)

Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)

Continuation from the previous 65 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Continuing writing about the improvements added to Clustered Columnstore Indexes (DataWarehousing & Business Intelligence) in SQL Server 2016, this blog post is a direct continuation from…