I did not hand it a plan with a spill in it. Everybody can find a spill. I handed it a plan with no warnings at all, where every number on the screen looked healthy, and the query underneath was reading five million rows to return seventeen.
For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with URGENT in the subject line. For other services, mention “Comprehensive Database Performance Health Check” in the subject.
Y2K: The Work Behind “Nothing Happened”
Y2K did not end in worldwide disaster. Its repairs, failures, and recoveries show why, and what database teams can learn about proving maintenance matters.
Fermat Left a Note in a Margin. Other People Spent 358 Years Finishing It.
That note kept mathematicians busy for the next three and a half centuries. Let us talk about what Fermat left in a margine.
Every Database Has These Seven Tables
You can walk into any company on earth, open the production database, and find the same seven tables. Different industry, different continent, different decade. The same seven tables.
NOLOCK Can Miss Rows: The Order That Was Never Missing
A row can vanish from your report while it is sitting safely in the table the entire time. Nobody deleted it. Nothing rolled back. The read simply walked past it.
Everyone Expected AI to Come From the Big Companies
Everyone expected AI to come from the big companies. They had the money, the data, the researchers and a twenty year head start. The research came out of those labs. The products did not, and the reason has very little to do with talent or budget.
UPDATE Without WHERE Clause: The Day Everyone Got a Raise
An UPDATE without WHERE clause changed 8,432 salaries. When ROLLBACK can help, and how to check the affected row count before COMMIT.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.