Log free space per volume from SQL Server volume metadata, keep one daily sample per mount point, and compare change with LAG.
Duplicate Statistics: Auto-Created Stats That Shadow Index Statistics
Find duplicate statistics on index-leading columns, compare freshness and sampling, and generate cautious DROP STATISTICS candidates.
KILL WITH STATUSONLY: How Long Will This Rollback Take?
Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
Reading Deadlock Graphs From the system_health Session
Read deadlock graphs from system_health, identify victims and resource owners, reproduce a two-session cycle, and choose a targeted fix.
Stale Statistics: Detecting and Updating Them
Detect stale statistics with update properties, review modification thresholds, and schedule targeted refreshes with recorded outcomes.
Capturing sp_WhoIsActive Snapshots to a Table Every Minute
Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.
Running DBCC CHECKDB on a Restored Copy Instead of Production
Run CHECKDB on a restored copy to validate a recoverable backup, retain the full check output, and understand what remains untested.