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…
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…
Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)
Continuation from the previous 125 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have a huge love for the DBCC CLONEDATABASE command – it has been made available (backported) to every SQL Server version starting with SQL Server…