Diagnose a many-to-many merge join and its worktable, verify true uniqueness, and compare join choices without changing legitimate matches.
Indexed Computed Columns: Speeding Up Code You Cannot Change
Use indexed computed columns to help fixed vendor queries on UPPER or CAST, while checking determinism and required SET options.
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
A deadlock investigation needs the graph and cooperation between DBAs and developers. I distinguish a blocking wait from a cyclic dependency.
Async Statistics Updates: Stopping Queries From Stalling
Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.
Consulting Wrap Up – What Next and How to Get Started
Use this consulting wrap up to keep a practical engagement checklist, choose the right service, and prepare the first email to get started.
Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem?
Learn to diagnose the same problem yourself, distinguish symptom relief from a root-cause fix, and know when a follow-up is useful.
Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?
Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.