Jack Corbett (6/10/2014)
First you have to define what you mean by fast.My first suggestion would be to batch the updates using explicit begin and commit tran statements and do Top N where you find the batch size that works the best for your situation. Obviously you need a way to be sure you are updating a new TOP N each time.
I usually practice this approach and it's good. N often varies and mainly depends on the volume of the update and on the hardware.
Igor Micev,My blog: www.igormicev.com