a coffee filtering process

Don’t optimize for ad hoc workloads as a best practice

(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held belief systems that don’t take new information into account, and how confirmation bias is not a good motivator for recommending best practices. Let’s talk about the
-> Continue reading Don’t optimize for ad hoc workloads as a best practice

Proposed SQL Server defaults: optimize for ad hoc workloads

(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 lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: optimize for ad hoc workloads

SQL Server logo

Fix SQL Server with one click

(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 Server default configuration is not recommended for production environments, and yet I have worked on many production environments that have been set up by people who don’t know that the
-> Continue reading Fix SQL Server with one click