(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: disable lightweight pooling
(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
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… Read More »How does the buffer pool work?
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… Read More »My brain hurts