: Updating 100,000+ rows at once can lock your table. It is better to run an UPDATE TOP (5000) command in a loop to maintain system responsiveness.
Common "sweet spots" range from 1,000 to 5,000 rows for high-concurrency environments. Larger batches (up to 100k) may be faster but increase the risk of locking. jcac10003oc2v10 update top