I am glad to share that the latest version of CISL – Columnstore Indexes Scripts Library 1.0.4 is finally released. By all means this should be the final release in the 1.0.x series, with the upcoming 1.1.x series to focus…
CISL 1.0.4 is released
Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)
Continuation from the previous 72 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Since the very first version of SQL Server the maximum size for the Delta-Stores as well as the compressed Row Groups was limited to 1048567 Rows.…
Columnstore Indexes – part 72 (“InMemory Operational Analytics”)
Continuation from the previous 71 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have previously written on the Rowstore Operational Analytics, and now it is the time to dive into the InMemory Operational Analytics in SQL Server 2016…
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”)
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…