There are 3 different MAXDOP scopes: instance, database and statement. Readers of my 16-versus-1 demonstration asked where to configure it.
Priority Boost and Performance – SQL in Sixty Seconds #131
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093
SQL Server 2019 is very easy but the real challenge is to uninstall SQL Server 2019 instance. Let us learn how we can do that in video.
How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092
Question: How to Install SQL Server 2019?
Answer: This is one of the unique blog posts in the history of SQLAuthority, it is merged blog post.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Boost SQL Server Priority appeared in the historical SSMS 18.5.1 interface. I showed where to inspect that engine setting.
WITH NORECOMPUTE: Stop Auto Updates on One Table
WITH NORECOMPUTE tells SQL Server to stop updating the statistics of one table automatically. This post sets it with UPDATE STATISTICS, proves that the modification counter keeps growing while nothing refreshes, and shows how to turn it off again. It also shows a safer option for the same problem, a persisted sample percent.
Deadlock Victim Selection: Protect One Transaction
Deadlock victim selection decides which of two blocked transactions SQL Server rolls back. This post shows the rules, sets DEADLOCK_PRIORITY on one procedure, reproduces a deadlock with two query windows, and shows what the setting cannot do. It ends with the two fixes that remove the deadlock itself.