An execution plan is SQL Server showing its working. Read it inside out, learn the six operators you actually meet, ignore the cost percentages, and compare estimated rows with actual rows instead.
Indexed Views: When the Faster Reads Are Worth It
Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
Scalar Functions and Performance
Scalar functions can hide row-by-row work in SQL Server; learn when inlining helps, how to inspect eligibility, and when a set-based rewrite wins.
What Lock Escalation Is and How to Stop It
Understand lock escalation, confirm it with evidence, and reduce its impact through smaller transactions, better access paths, and modern locking.
SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.
SQL SERVER – Find Details for Statistics of Whole Database
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.