Too many indexes on a SQL Server table can slow every write; learn how to identify overlapping indexes, measure their value, and remove them safely.
SQL SERVER – BI Quiz – Troubleshooting Cube Performance
My SQL BI Quiz question: your cube suddenly returns data very slowly. What three things would you check first when troubleshooting cube performance?
SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
A puzzle for you: auto update is on and I insert 10 times more rows, yet the statistics are not updated. Why, and how can they update automatically?
PAGEIOLATCH_SH Waits: Slow Storage or Too Many Reads
Diagnose PAGEIOLATCH_SH waits by comparing file read latency with Query Store physical reads before blaming storage or changing indexes.
Finding the Slowest Stored Procedures With sys.dm_exec_procedure_stats
Find the slowest stored procedures with cache statistics, compare CPU and reads, and use two snapshots to isolate one busy hour.
SELECT * in Production Code: The Hidden Costs
See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.
SQL SERVER – TempDB in RAM for Performance
Can you put TempDB in RAM for better performance? A friend asked me this, and here is why SQL Server no longer needs it and what I prefer instead.