Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)

Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)

Continuation from the previous 74 parts, the whole series can be found at http://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…

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Continuation from the previous 73 parts, the whole series can be found at http://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…