Use this debugging tools which will let you see what process is hanging on what. You need to run the userdump.exe file then view it with this tool; you may...

Use this debugging tools which will let you see what process is hanging on what. You need to run the userdump.exe file then view it with this tool; you may...

xp_sendmail, need administrator account and watch out for saving any modification by other users to this job (still will show that you're the owner even if someone else not Admin,...

Your boss is right, no more than 4 joins (unless if each table reside on a different drive), use declare myTable as Table instead of #tempTable, this is new in...