For the MSSQL locking, you should probably change the transaction isolation level instead of using NOLOCK everywhere. I think it's a horrible wart that you hav

For the MSSQL locking, you should probably change the transaction isolation level instead of using NOLOCK everywhere. I think it's a horrible wart that you have to do that for every session, though. The default can't be changed.