After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL Server 2014. The version 1.1.0 of the CISL (Columnstore Indexes Scrtips Library), free & open source is live and available…
Continuation from the previous 74 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post focuses on one of the newest additions to SQL Server 2016, the feature that most probably has gained a universal appraisal since the…
Continuation from the previous 73 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Row Group merging & cleanup is a very long waited improvement that came out in SQL Server 2016. Once Microsoft has announced this functionality, everyone who…
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…
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.…