Continuation from the previous 58 parts, the whole series can be found at https://www.nikoport.com/columnstore/. SQL Server 2016 brings a number of significant improvements in the relation of Columnstore Indexes performance and improvements in String Predicate Pushdown were already described in…
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…