posted on Friday, November 05, 2004 8:40 AM
by
amachanic
Batching in SQL Server
Steve Jones of SQLServerCentral.com posted a good article about batching updates in SQL Server. He shows why it's not always best to do things in a 100% set-based manner. Blocking and locking during large updates can be mitigated by doing the work in smaller chunks. Definitely a good technique for the toolbox of anyone who has to deal with modifying big datasets.