The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL – Columnstore Indexes Scripts Library in 2016. The current version is 1.0.4 but here you can already see what I…
CISL Roadmap
How to use CISL – the Columnstore Indexes Scripts Library
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes Scripts Library, which allows to have a deeper insight into the database that uses or can use Columnstore Indexes.…
CISL 1.0.4 is released
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…
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…