Prev Question
Next Question

You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical.
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:
When importing data into a heap by using the INSERT INTO SELECT <columns> FROM statement, you can
enable optimized logging and locking for the statement by specifying the TABLOCK hint for the target table.
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

Prev Question
Next Question

Leave a Reply

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