Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
What is a trusted constraint in SQL Server? Many experts do not know, so instead of a definition I explain it with a simple check constraint example.
Implicit Conversions That Quietly Turn Seeks Into Scans
Find implicit conversions in SQL Server plans, compare parameter and column types, and fix type contracts without losing Unicode data.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server? Here are the steps I use to move a busy LDF or MDF file to a quieter drive.
Reduce IO Waits in SQL Server: Read the Waits First
To reduce IO waits in SQL Server, first name the wait. This post explains the main IO wait types and measures two of them for a single session on a demo database. It then shows how to check file latency and which fix matches each wait.
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
When should you use sort_in_tempdb for rebuilding indexes? A DBA asked me in a Health Check, and the simple answer is when TempDB sits on fast, separate drives.
The Ascending Key Problem: Estimates for Today’s New Rows
Diagnose ascending key estimates with histogram boundaries, modification counts, and controlled comparisons before updating statistics.