Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.
Parameter Types From .NET: Stopping Implicit Conversions at the Source
Match parameter types from .NET to SQL Server columns, avoid implicit conversions, and inspect cached plans for mismatched strings.
SSAS Cube Performance: Diagnosing a Sudden Slowdown
SSAS cube performance diagnosis starts with the exact slow request. Follow storage, MDX calculations, cache, processing, and resource evidence before choosing a fix.
Too Many Indexes on One Table
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.
Troubleshooting Cube Performance: Three Checks
Diagnose cube performance by comparing the same MDX query, processing changes and resource pressure before choosing a repair.
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.