Question: How to Use a CASE statement in the WHERE Clause? Answer: First of all – CASE is not a statement but rather an expression.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Read Heavy Workload or Write Heavy: Measure It in SQL Server
To tell a read heavy workload from a write heavy one, compare what the server reads with what it changes, and measure it over a window. This post counts reads and writes per table, reads the buffer and log counters with two snapshots, and explains what each lens misses.
PRINT Date Format in SQL Server: PRINT Versus SELECT
The PRINT date format differs from the SELECT format, because PRINT converts the value to text first. This post tests PRINT with six date and time types, shows why joining text and a datetime fails with Msg 241, shows how the session language changes the month name, and gives the formats that stay the same everywhere.
Actual Execution Plan in SQL Server: Graphical, Text and XML
An actual execution plan shows how SQL Server really ran a query, with the true row counts beside the estimates. This post gets the plan three ways, as a graphical plan, as text with SET STATISTICS PROFILE and as XML, and uses a demo table to show how the estimate and the actual number can disagree.
IO Stalls by Database File: Find the File to Move
IO stalls measure how long SQL Server waited for the disk, file by file. This post ranks the files of a demo database by stall time, measures a workload with two snapshots, lists the busiest files of a whole instance, and explains how to pick the one file that belongs on the new drive.
Immutable Backups: Keeping a Copy Ransomware Cannot Delete
Design immutable backups with enforced retention, separate storage access, offline recovery material, checksum checks, and restore tests.
Remove Extra tempdb Files in SQL Server Safely
To remove extra tempdb files, empty each file first with DBCC SHRINKFILE and then remove it with ALTER DATABASE. This post checks the file count and the allocation waits before you start, rehearses both steps on a demo database, shows the tempdb statements with their undo, and explains why emptying can fail.
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.