samking (8/6/2014)
Hi friends,I am running an update query.
It is taking long time. To find the estimated completion time i checked sys.dm_exec_request or sys.dm_exec_session or sp_who2 but there is no clue. It is showing as zero.
can any one help on this please.
Regards,
SAM
Post the query, please. There's a typcial problem that many folks write into their update queries without knowing about it. To summarize the problem, if the UPDATE contains a JOIN, the target table MUST absolutely appear in the FROM clause. Using tablename.columnname is NOT sufficient and that form of UPDATE never appears in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.