A join hint in the FROM clause quietly fixes the join order. I show the warning, three plans side by side, and the softer query-level alternative.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Checking XML Index Size Against the Table It Belongs To
An XML index can outweigh the table it serves. Here is how I measure each XML structure next to the base table, and what to test before dropping one.
Updatable Views: When INSERT and UPDATE Work Through a View
A view is only a doorway to the table behind it. I show which writes get through, which get rejected, and why CHECK OPTION earns its place.
ALTER TABLE REBUILD: Fixing a Heap Without a Clustered Index
A heap with widening rows collects forwarded records. Here is how to measure them, fix them and know when the fix will not last.
Explicit Identity Values: Loading Rows With Their Old Keys
Moving rows and keeping their old keys? Here is the safe order of steps, and the counter check that saves you from a collision.
Comparing Session SET Options Between SSMS and the Application
Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.
Offloading Reports to a Readable Secondary
Readable secondary replicas can serve reports away from a SQL Server primary; learn routing, lag, licensing, and query differences to test.
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.