Locks in sql server

Question

Locks in sql server

r.dilliprasad

Valued Member

Points: 71
More actions
March 19, 2013 at 6:06 am

#275392

Can any one please explain locks like how it works & when it will require

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

AJ@SQL SSC Eights! Points: 811 More actions · Answer 1

Please go through this article: http://www.sqlteam.com/article/introduction-to-locking-in-sql-server

Also spend some time in msdn article on Locking. Please post your specific questions then, would be great to discuss then.

r.dilliprasad Valued Member Points: 71 More actions · Answer 2

r.dilliprasad

Valued Member

Points: 71

March 19, 2013 at 7:56 am

#1598437

Thank u very much...!

prasad

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

There's a decent coverage at the start of chapter 6 in http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass