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.
Consulting 101 – Why Do I Never Take Control of Computers Remotely?
I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.