How large are the data set which its trying to update? small at 2k or 2million.

you ,might want to look at carrying our the updates in a batched process happen which would stop the tempdb from growing