title: Getting info about running update query
body: <p>On Sql Server 2008, I have a slow-running update query that has been working for 3 hours. Is there any way to get any statistics (say, how many rows have changed so far or something else) about this execution (of course, while executing) ? So that I can make a decision between canceling query and optimize it or let it finish.</p>
  
  <p>Or else, should I have done something before execution ? If so, what can be done before execution for getting info about an update query while it is running. (of course, without affecting the performance largely)</p>
  
  <p><em>an update for clarifying:</em><br>
  the update statement mentioned in question is (e.g.):<br>
  UPDATE myTable SET col_A = 'value1' WHERE col_B = 'value2'<br>
  In other words, it is a <em>single</em> query that updates whole table</p>