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.
Linked Servers and What Goes Wrong With Them
Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.