MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Browse by Tags -

in Search

Browse by Tags

All Tags » sql server » readpast (RSS)
  • Deadlock with READPAST on join query - how this is possible?

    Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...
    Posted to Forum by plauten on 07-01-2008
Page 1 of 1 (1 items)