Unfortunately no.

Jacob, I just checked all the tables which are used in the query and they are pretty much all tables except Account record and Employee. The biggest table we have...

Thanks everyone for help.

Permission problem solved and trace file has been created.

Grazie.

This works. But what I want to keep track of Modified_Date as well? Does that mean a new trigger?
create trigger trg_Update
on Department
after update
as
set...

Thanks Sue, It looks like a decent tool which I am planning on using to test. I appreciate the help.

I ran the query from Pinal Dave which is here to see what was causing the tempdb to grow but no luck.

I reduced the size but it didn't work.

Also, is there any book or courses that someone can recommend where I can learn advanced tsql programming. I have learn from w3school but this SELECT @fileDate = convert(varchar(20),...