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

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

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response