This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. With the appearance of the CTP 3.2 of the Sql Server 2019 and being almost a year of…
Batch Mode – part 5 (“TPC-H Queries”)
Announcing “Columnstore & Batch Execution Mode” Channel
It is time. I have been thinking about this for about a year and playing with the idea for way too long, with the concrete plans for the January of 2018, than August 2018 … Anyway – here we go…
Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)
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…
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…