|
|
Posted by Erland Sommarskog on 10/12/05 10:33
Tom (nospam@yahoo.com) writes:
> There is no guarantee that the record in a smaller chunk will not be
> locked by another user.
I did not really recognize the error messages that Adi got, but it seemed
to me that the problem was to get locks on the table he is inserting to,
because of resource constraints, not because he was locked by another
user.
And even in a blocking scenario, smaller batches help as it reduces the
risk for exposure for blocking.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|