You are optimizing several Transact-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the page level rather than at the table or row level.

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: 15219 | Points: 40
Select from following answers:
  1. ROWLOCK
  2. PAGLOCK
  3. TABLOCK
  4. All Above

Show Correct Answer


Asked In: measureup.com | Alert Moderator 

Comments or Responses

Login to post response