Bulk Update Locks
A bulk update lock is a special type of lock used only when bulk copying data into a table using the bcp
utility or the BULK INSERT
command. This special lock is used for these operations only when either the TABLOCK
hint is specified to bcp
or the BULK INSERT
command or when the table lock on bulk load
table option has been set for the table. Bulk update locks allow multiple bulk copy processes to bulk copy data into the same table in parallel, while preventing other processes that are not bulk copying data from accessing the table. If there are any indexes on the table, or any other processes already holding locks on the table, a bulk update lock cannot be granted.
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.