Word wrap in SSMS folds a long line of T-SQL at the edge of the window, so you read it without scrolling sideways. This post shows where to turn it on for every window, how to show the wrap marks, how to switch it for one window, and why it never changes your script.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – What is Logical Read?
A logical read requests a database page through the buffer cache. A customer asked about that measure after my STATISTICS IO video.
SQL SERVER – 3 Different Ways to Set MAXDOP
There are 3 different MAXDOP scopes: instance, database and statement. Readers of my 16-versus-1 demonstration asked where to configure it.
SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
SQL SERVER – PREEMPTIVE Waits and Scheduler Context
Preemptive waits can measure work outside SQL Server cooperative scheduling. A customer asked about their increase during a health check.
Multiple OPTIMIZE FOR Hints in One Query: Value or UNKNOWN
Multiple OPTIMIZE FOR hints in one query are written as one list: each parameter gets its own value or UNKNOWN. This post compiles the same query six ways, reads the compile values and estimated rows from the plan cache, and shows which combinations SQL Server accepts.
SQL SERVER – DISTINCT Does Not Guarantee ORDER BY
DISTINCT removes duplicate result rows without guaranteeing their order. My original claim that it always sorts output was incorrect.
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.