Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
From what I am hearing by some people, a lot of Banks use BASE rather than ACID. In BASE, nolock would be ok because they write new rows 15 or 16 times or something like that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events