business intelligence

Columnstore Indexes – part 58 (“String Predicate Pushdown”)

Columnstore Indexes – part 58 (“String Predicate Pushdown”)

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…

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 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…

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 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…