Difference between "RID" and "KEY" lock(s) in SQL Server

 Posted by PandianS on 1/29/2011 | Category: Sql Server Interview questions | Views: 8291 | Points: 40
Answer:

RID:- Row ID. A lock on a single row in a heap (Heap is a table which doesn't have Clustered Index)

KEY:- A Lock on a single row in an Index

Cheers
www.sqlserverbuddy.blogspot.com


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response