avoiding table lock whe updating million of records at a time
if we must have to update millions of records at a time, what is the
possible ways to avoid table lock.
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.
Show quoteHide quote
"SQL Ken" <SQLemail@example.com> wrote in message
> if we must have to update millions of records at a time, what is the
> possible ways to avoid table lock.