Noetic DBA (12/14/2012)
Also, the tempdb is growing because it is not checkpointing properly.
Did you mean to say that heavy DML operation consuming the space (like work table , tabl spooling or index spooling )
then this can be avoided by breaking the query in to smaller parts
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)