MAXDOP guidelines start from the number of CPUs and NUMA nodes on the server. This post builds three read-only queries that show those facts, the current MAXDOP and cost threshold, and the memory settings. It also shows how to read the answer without changing anything.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Many-to-Many Merge Join and the Worktable in STATISTICS IO
Diagnose a many-to-many merge join and its worktable, verify true uniqueness, and compare join choices without changing legitimate matches.
Spotting Unusually Small Backups Against Each Database’s Average
Flag unusually small backups against database-specific history, use aggregate filtering, and investigate alerts without assuming data loss.
Splitting an Amount Across Rows Without Losing a Cent
Make splitting an amount preserve every cent by checking rounded shares, allocating weighted remainders, and documenting deterministic ties.
Plan Properties Window: Where the Useful Numbers Hide
The execution plan picture only shows the shape. The properties window shows what really happened, and I walk through it on a tiny example.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Does the ARITHABORT setting hurt SQL Server performance? Yes, because with ARITHABORT OFF SQL Server can build a very different plan and queries may slow down.
Masking Test Data With REGEXP_REPLACE in SQL Server 2025
Before a production copy reaches a developer, replace the real emails and phone numbers. Here is a small, checked way to do it with REGEXP_REPLACE.
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.