I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL – Columnstore Indexes Scripts Library is finally public – the 1.3.0 version. The most important part of this release is the support of the SQL Server 2016 & Azure SQLDatabase – all 3 scenarios (Nonclustered Columnstore, Disk-based Clustered Columnstore & the Memory-Optimised Clustered Columnstore Indexes) are included.
You will be able to explore all the important new architecture objects, such as Deleted Buffer & Deleted Table, plus the scripts for every version supports the new output results, even though there were no In-Memory tables in SQL Server 2012 for example.
The second most exciting part is the news that this version has 2 new versions of maintenance solution for the Columnstore Indexes – SQL Server 2016 & Azure SQLDatabase are now have their implementations with support for rebuilds and reorganize operation where needed, including the invocation of the sys.sp_memory_optimized_cs_migration stored procedure for the InMemory Columnstore tables.
Another important aspect of the maintenance solutions for all relevant supported versions (SQL Server 2014, SQL Server 2016) is that now the maintenance solution recognises the AlwaysOn Availability Group and should the maintenance be executed on the secondary replica, it will automatically end the execution, since there is no maintenance on the secondary that can be executed currently.
Plus, the information on the latest SQL Server Service Packs & Cumulative Updates and their respective resolved bugs were included, and naturally a number of bugs were solved :)
There is one new very important parameter for the SQL Server 2014, which was introduced for the Memory-Optimised tables in Suggested Tables.sql script:
@updateMemoryOptimisedStat which is set to to false by default. When activated, this parameter will solve one of the problems of the sys.partitions DMV for InMemory tables – because the information within it, is not updated automatically, and so one can’t be sure how many rows are wishing SQL Server 2014 Memory Optimised table, unless doing a Count(*) operation or updating statistics manually. My solution for CISL was to enable manual statistics update for the considered tables.
So go ahead, and download the 1.3.0 version of the CISL!