Wednesday, April 24, 2013

Difference between NO LOCK and READPAST in SQL Server

I learned the difference today between NO LOCK and READPAST thanks to Tim Chapman. I suspect we have an SSIS package that locks the table for a significant amount of time - and I think we're going to solve the problem using READPAST. Check out Tim's post to read up on the difference between NO LOCK and READPAST.

No comments:

Post a Comment