(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…
(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…
Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we dive too deeply into the buffer pool, we need to remind ourselves of a few…
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because…