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.
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
