Continuation from the previous 57 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have previously blogged on the predicate pushdown matter in the post Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”), and from the published…
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the series that is going strong for 60 different posts (57 traditional + 3 azure-focused ones) since then. On this day,…
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…
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…