SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Unable to Start SQL Browser
The SQL Browser service on my VM went from Started back to Stopped every time. Here is what the Application Event Log showed and how I fixed it.
Geometry Datatype – Line String Behavior Enhancements
A developer saw slow performance with line strings in the Geometry datatype. I share what I found and the line string behavior enhancements that help.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
Do you use the actual or the estimated execution plan? A candidate asked me this in an interview. I always use the actual plan, and here is why.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
My notes on the lesser used parts of Activity Monitor in SSMS, like Resource Waits, and how the tool builds them from sys.dm_os_wait_stats at each refresh.
Offloading Backups to a Secondary Replica: Notes from the Field #108
Offloading backups to a secondary replica takes work off the primary server. In Notes from the Field #108, Eduardo Castro explains backup priority and read-only routing for AlwaysOn availability groups.
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.