Continuation from the previous 126 parts, the whole series can be found at https://www.nikoport.com/columnstore/. With the appearance of the Batch Mode on the Rowstore Indexes (FINALLY!), the big question (aka Elefant) is in the room – DO WE STILL NEED…
Master Data Services in SQL Server 2019
I have a very special relationship with MDS (Master Data Services), and even though for some reason I have never blogged about it, I feel like SQL Server 2019 is bringing a good reason to blog about. To define my…
Batch Mode – part 4 (“Some of the limitations”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. This post will focus on some of the initial limitations of the Batch Execution Mode on the Rowstore…
Batch Mode – part 3 (“Basic Heuristics and Analysis”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. Question When does the Query Optimiser decides to let the Batch Mode to take over the query execution…
Batch Mode – part 2 (“Batch Mode on Rowstore in Basics”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. With the initial public CTP release of the SQL Server 2019 – the CTP 2.0 we have finally…