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… Read More »MAXDOP: not quite what you think
max degree of parallelism
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… Read More »Better SQL Server CPU defaults in 2019
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… Read More »Proposed SQL Server defaults: cost threshold for parallelism