Using Table Locks Hints

in data •  5 years ago 

Check out the discussion about table lock hints in the video TSQL: TABLOCK vs. TABLOCKX (vs. Normal Process). We look at the actual results of using the different hints and consider whether we'd want to use this in our environment. Keep in mind that one consideration for using these hints would be whether we're running an OLTP vs OLAP environment. OLAP environments, especially with specific loading times, may allow for more table lock hints.

Automating ETL
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.

Remember that using these hints will lock a table appropriately based on our needs. Provided this is what we want, we should expect users to observe that their access during loads is encumbered. This is not a problem for scheduled loads and reports.

YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!