A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.
SQL SERVER – Measure CPU Pressure – Detect CPU Pressure
How to measure CPU pressure in SQL Server and tell whether your server needs a faster CPU or more CPUs, using simple scripts and signs.
Calculating the Cost of a Slow Query
Cost of a slow query includes frequency, CPU, reads, waits, and user time; learn to turn SQL Server measurements into a practical tuning priority.
Resource Governor: Capping a Runaway Report
Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
SQL Server – Understanding Table Hints with Examples – 2
A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.
Finding Sleeping Sessions That Still Hold Locks
Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.