SQL Server Performance Forum – Threads Archive
shared lock
Hi, when will i get shared lock in sql server 2000? i am performing 2 operations select,update on the same table is there any possiblity for occurring shared lock? thanksBy default, SQL Server uses shared locks on any rows that are queried by a query or stored procedure. Sometimes these shared row locks are escalated to page and tables locks, reducing concurrency in your database. If the query is long-running, it can prevent other users from accessing the rows they need to UPDATE or DELETE rows on a timely basis. fromhttp://www.sql-server-performance.com/reducing_locks_hints.asp —————————————-
http://spaces.msn.com/members/dineshasanka
Also read this
http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm Madhivanan Failing to plan is Planning to fail
]]>