What is SQL Deadlock?

Posted by Sabarimahesh under Sql Server on 3/27/2012 | Points: 10 | Views : 1350 | Status : [Member] | Replies : 3
What is SQL Deadlock?

Asked in Interview

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M



Responses

Posted by: Deepakji on: 3/27/2012 [Member] Starter | Points: 25

Up
0
Down
Deadlock is a unique situation in a multi user system that causes two or more users to wait indefinitely for a locked resource. First user needs a resource locked by the second user and the second user needs a resource locked by the first user. To avoid dead locks, avoid using exclusive table lock and if using, use it in the same sequence and use Commit frequently to release locks.

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/27/2012 [Member] Silver | Points: 25

Up
0
Down
When two users wait for each other for others resources,deadlock comes to result

Refer to :
http://www.dotnetfunda.com/interview/exam449-what-is-a-deadlock.aspx
http://www.coolinterview.com/interview/25688/

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response