if we must have to update millions of records at a time, what is the
possible ways to avoid table lock.

Thanks

Ken

You will have to take into account
1. Table lock - is this a highly transactional table? If so, your update
should be out of processing hours.
2. Transaction Log - Performing updates and such high numbers of data will
cause your log to increase in szie and potentially cause the log to fill up.

I suggest you do the updates in smaller batches like hundreds of thousands
rather than a big one off update.
Immy


Show quoteHide quote

Update Statement
Date Range
UNDO
XP_SENDMAIL Overload in SQL 2005
how to do this