I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released. The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups…
Continuation from the previous 110 parts, the whole series can be found at https://www.nikoport.com/columnstore/. The topic of the Segment Elimination (aka Row Group Elimination) is something that I keep on blogging on through all the years, but given that Joe…
Continuation from the previous 109 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…
Continuation from the previous 108 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch…
Continuation from the previous 107 parts, the whole series can be found at https://www.nikoport.com/columnstore/ As we are approaching the RTM (release to manufacturing) of the SQL Server 2017, I decided to focus on the implemented features in the upcoming release,…