Using this T-SQL statement this process should take about 2 minutes. We know this by limiting the update to 100,000 rows. (the table has an identity field so we can control how many and where to start). 100,000 rows update in 11 sec. That
translates to about 2 minutes for the entire million row table. There is some kind of problem that resolves itself after a while. We timed the statement in a larger proc where it was contained and it eventually finished after 2 to 4 hours.
[Cost] = dw_Prod.
View Complete Post