You are optimizing several T-SQL statements. You have determined that a particular statement will perform more efficiently if rows in a table locked by another transaction are skipped rather than waiting for the locks to be released.

Which of the following table hints will you use in your Transact-SQL statements when performing optimization?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 15604 | Points: 40
Select from following answers:
  1. READPAST
  2. TABLOCK
  3. PAGLOCK
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response