SQL Server Performance Forum – Threads Archive
locks in sqlserver 2005is there any good documentation about the locks, since i just started to working on locks i need to know more information, locks, types , esculation thanks
Start with Books online for sQL 2005.
My blog –http://sqlserver-qa.net/blogs/tools…rrency-locking-with-asp-net-applications.aspx
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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
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.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.