Continuation from the previous 75 parts, the whole series can be found at https://www.nikoport.com/columnstore/. While playing with SQL Server 2016 CTP 3.2, I have found some interesting feature being mentioned inside the engine. The strange thing was called a compression…
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post that would explain the current parameters and the way to use it are needed. Responding to this inner calling, here…
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…