The Nolock vs Snapshot debugging trick
Ever debugged an application that changes stuff in the database and suddenly realize you would want to compare it to the old value? I gotchu
Ever debugged an application that changes stuff in the database and suddenly realize you would want to compare it to the old value? I gotchu
Ever created an index where the hidden clustered index key was an intentional second sort key? Please don't.
Option (recompile) can taint Temp Tables? Yup. It's spreading its disease to every query the temp tables touches...
How to make a query faster, using temp tables.
Ever had weird things happen to tables variables inside cursors? You're not the only one...
So you've learned all there is to know about SQL Server and you are tuning queries left and right and you stumble upon a query that is...
This blog was never meant to go from point A to point Z in regards to difficulty or knowledge requirements. I just wanted to blog about...
Once upon a time, I was sitting in my office, minding my own business, when this guy walked by, looking for someone, anyone who knows SQL...
Deadlocks are hard... Deadlocks can creep up at seemingly random occasions and slow things down for a bit and then tell your error log...
In case you didn't know, if you want to retrieve rows from a table that doesn't have a connection to another table, you can write a left...