Buy Questpond's video subscriptions on
huge discount
.
Online: 1665
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
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
Login to post response
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 ...