You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistoncal.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement. Which table hint should you use?
A.
HOLDLOCK
B.
ROWLOCK
C.
XLOCK
D.
UPDLOCK
E.
TABLOCK
Explanation:
Reference: http://technet.microsoft.com/en-us/library/ms189857.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms187373.aspx
Answer is Tablock
D
http://stackoverflow.com/questions/18680943/tablock-for-optimize-transaction-logging-for-insert-select-statement
One of our visitors a short while ago suggested the following website.
although web-sites we backlink to below are considerably not connected to ours, we really feel they’re basically really worth a go by means of, so have a look
The information and facts mentioned inside the article are a few of the most effective readily available
Here are some of the web-sites we recommend for our visitors
we came across a cool web page that you simply could delight in. Take a look if you want
D TabLock
E – TabLock