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…
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…
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…
Continuation from the previous 124 parts, the whole series can be found at https://www.nikoport.com/columnstore/. It is quite emblematic that this blog post is following the number 124 in the series – Columnstore Indexes – part 124 (“Estimate Columnstore Compression”), because…
It is quite strange to write an article about Resumable Online Index Creation 14 months after writing about Resumable Online Index Rebuild operation, because from the physical world logic there should be first the initial creation and then rebuild process,…