Columnstore Indexes – part 57 (“Segment Alignment Maintenance”)

Columnstore Indexes – part 57 (“Segment Alignment Maintenance”)

Continuation from the previous 56 parts, the whole series can be found at http://www.nikoport.com/columnstore/ In this post I want to focus on a very important aspect of Columnstore Indexes maintenance – Segment Alignment. I have extensively blogged and presented on…

Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)

Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)

Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/ Before starting to dive into the specific of all those great-sounding and juicy improvements in SQL Server 2016 for Columnstore Indexes, I wanted to kick off…

Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)

Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)

Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/ The architectural changes in the upcoming SQL Server 2016 are bringing some very important & long-awaited improvements for the complete Columnstore Indexes architecture in Microsoft SQL…