Hi,
using the tool toad (against oracle) there is a view "long ops" where you can see long running operations and a estimation how long they will take. This estimation is surprisingly exact. IMO it works somehow by interpreting existing pages and pages already read. If you build a dwh with elt this can be very informative.
So, is there a possibility to view "longops" in SQL Sever, perhaps using DMV's?
Tobias