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