shared lock | SQL Server Performance Forums

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? thanks
By 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. from —————————————-

Also read this Madhivanan Failing to plan is Planning to fail