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”)
SQL Graph, part VI – Closeness Centrality
This is the 6th blog post in the growing series of blogpost on the Graph features within SQL Server and Azure SQL Database that started at SQL Graph, part I. This time I want to focus on one of the…
SQL Graph, part V – Shortest Path
This is the 5th blog post in the growing series of blogpost on the Graph features within SQL Server and Azure SQL Database that started at SQL Graph, part I. This time we are focusing on the one of the…
Updating Statistics on Secondary Replicas of the Availability Groups
UPDATE 25th of June 2019: The item related to this topic on Azure Feedback: Allow Updating Statistics on the Secondary Replicas of the Availability Groups We all love and use the wonderful features of the Availability Groups on the secondary…
SET Statistics IO Update in SQL Server 2019
Playing with SQL Server 2019 CTPs for some time, I have noticed some very exciting feature that I did not see mentioned by anyone before. The feature if you think about it, is so straight and obvious that after reading…