cost threshold for parallelism

MAXDOP: not quite what you think

by Randolph
July 15, 2020September 16, 2022

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

Proposed SQL Server defaults: cost threshold for parallelism

by Randolph
February 13, 2019September 16, 2022

(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

Fix SQL Server with one click

by Randolph
October 17, 2018September 16, 2022

(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL… Read More »Fix SQL Server with one click