SQL Server Performance Forum – Threads Archive
locks in sqlserver 2005
is there any good documentation about the locks, since i just started to working on locks i need to know more information, locks, types , esculation thanksStart with Books online for sQL 2005.
My blog –http://sqlserver-qa.net/blogs/tools…rrency-locking-with-asp-net-applications.aspx
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following from BOL and SQL Server Storage Engine Blog… SQL Server 2005 Books Online
Lock Compatibility
http://msdn2.microsoft.com/en-us/library/ms186396.aspx Locking in the Database Engine
http://msdn2.microsoft.com/en-us/library/ms190615.aspx Lock Escalation (Database Engine
http://msdn2.microsoft.com/en-us/library/ms184286.aspx http://blogs.msdn.com/sqlserverstorageengine/archive/2006/05/17/600132.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>