Golfer22 (1/1/2013)
I believe hash joins can cause growth in the tempdb if there is insufficient memory. I don't think nested loops do.
No, I do not think nested loops would affect tempdb.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato