Archive
Archive for March 19, 2011
Is WITH (READPAST) affected by readlocks – MSDN TSQL forum
March 19, 2011
Leave a comment
–> Question:
If a transaction calls a SELECT using the table hint WITH(READPAST)… will it skip rows that are locked by other SELECT statements that are in READ COMMITTED mode and are issuing shared locks?
ie. Does READPAST skip rows that are locked by SELECT statements, not just UPDATE and INSERT statements?
–> Answer:
I don’t think READPAST will skip rows locked by SELECT statement, but only in UPDATE & DELETEs.
Check here for an example and demo: Difference between NOLOCK and READPAST table hints
You may also check a similar old post in MSDN forum for more into.
Ref link.
Categories: SQL Server Questions
MSDN TSQL forum, Read Lock, READPAST, SHARED Locks
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 