top of page

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

Option (recompile) can taint Temp Tables

Option (recompile) can taint Temp Tables? Yup. It's spreading its disease to every query the temp tables touches...

Datatype implicit conversions will force index scans

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...

Temporal tables and the start time paradox

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...

How to solve a deadlock with an index

Deadlocks are hard... Deadlocks can creep up at seemingly random occasions and slow things down for a bit and then tell your error log...

Blog: Blog2
bottom of page