Use indexed computed columns to help fixed vendor queries on UPPER or CAST, while checking determinism and required SET options.
Async Statistics Updates: Stopping Queries From Stalling
Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
How do you limit the output of Varchar(max) or Nvarchar(max) in a SELECT statement? A simple trick does it, and it works for varbinary(max), text and ntext too.
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.