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
DBAs blame developers and developers blame DBAs for every deadlock. Here is a brief history of deadlocks and a modern approach to resolving them together.
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.
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.