Continuation from the previous 56 parts, the whole series can be found at https://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…
I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I can’t get a real sleep, no matter how hard I try. PASS Summit is the biggest and the most important…
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it was the right moment to expand the ways of teaching & spreading information on the Columnstore Indexes and we…
Continuation from the previous 55 parts, the whole series can be found at https://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…
Continuation from the previous 54 parts, the whole series can be found at https://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…