This blog post is a continuation of a small series of posts that I am writing about Azure SQL DW Materialized Views, and you can catch up the initial things in Azure SQL DW Materialized Views (part 1). In this…
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…
Resumable Online Index Creation
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,…
Resumable Online Index Rebuild
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable…