Columnstore Indexes – part 71 (“Change Data Capture, Change Tracking & Temporal”)

Columnstore Indexes – part 71 (“Change Data Capture, Change Tracking & Temporal”)

Continuation from the previous 70 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In the SQL Server world of data modification tracking, there are 2 very important features, which are called Change Data Capture (CDC) and Change Tracking (CT).…

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…