Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Consulting 102 – What Do I Promise in Every Engagement?
Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.