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

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : Difference between String and string in c#?

Next > : What components will be published when deploy a we ...

Comments or Responses

More Interview Questions by PandianS

Difference between PAD_Index and FillFactor ?
Limitations of using AWE Memory in SQL Server
To identify the Expiration date of database backup file
Difference between Backup Dump and Backup Device ?
What is the purpose of Model database ?
How the SELECT statement parsed/executed by the SQL Server engine ?
What are the performance counters used to monitor the Backup I/O perfo ...
How to enable compressed backup ?

Latest Interview Questions

What components will be published when deploy a webservice application ...
What is SOAP Protocol?
Which of these event handlers is fired whenever the request is sent fo ...
What is aggregate dependency?
What is the disadvantage of LINQ over stored procedures?
What are the advantages of LINQ over Stored Procedures?
What is determined by the Culture and UICulture values?
What is the difference between the Select clause and SelectMany() meth ...
More ...