Continuation from the previous 59 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is dedicated to some of the major improvements in SQL Server 2016, related to the Batch Execution Mode. By all means this list…
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…
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…
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…