MAXDOP: not quite what you think
An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at Microsoft. First though, some background on…
Better SQL Server CPU defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on the Windows version. On the Database…
Proposed SQL Server defaults: cost threshold for parallelism
(This post was updated on 5 February 2022). A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable…