Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.
SQL SERVER – sp_readrequest – Long Running Process
sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
Temporal History Queries: Indexing the History Table for Speed
Your current table is tiny, but the AS OF question hides in the history table. See the reads before and after a key-first index, and what it costs.
Slow Database Creation in SQL Server: Causes and Fixes
Slow database creation in SQL Server comes down to its files: how big they are, and whether SQL Server must zero every byte. This post checks the three usual suspects, the size of the model database, instant file initialization and the log file, and times each one with a script. It also shows the wait type to look for while a large CREATE DATABASE runs.
SQL Server Performance Mistakes: Three Checks to Run Today
SQL Server performance mistakes hide in the settings, the files and the code. This post checks four server settings, shows poor file growth and its fix, and measures two code mistakes, a function on an indexed column and a data type mismatch, in logical reads.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
SQL SERVER – CLONEDATABASE: Generate Statistics and Schema Only Copy of the Database
CLONEDATABASE can Generate Statistics and schema-only diagnostic copies without copying table rows. I use that distinction when investigating optimizer behavior.







