You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical.

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:

Reference: http://technet.microsoft.com/en-us/library/ms189857.aspx

Refe

rence: http://msdn.microsoft.com/en-us/library/ms187373.aspx