Press "Enter" to skip to content

The Power of TABLOCK for Bulk Insertion

Mehdi Ghapanvari explains why TABLOCK can be useful for bulk inserts:

Does bulk insert performance improve when you use the TABLOCK hint? In some cases, YES! Let’s take a look at this in action to see how this hint could improve insert performance when using SQL bulk insert with TABLOCK.

Of course, standard TABLOCK concurrency rules (specifically, the lack of concurrency) apply.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.