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.

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