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

Query help
xp_cmdshell - works with string in one format but not in another -
Need help with self-join
done in a single statement
SQL problem to solve...
passing a table from one sp to another sp
Temp Table Indexing??
data disappearing in a trigger
Shipping 2
training