There is a long time topic that has been quite an important item for the data platforms dealing with a significant amount of data – the approximate calculations. Anyone who is not familiar with this topic, can visit the Wikipedia…
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…