Home Forums SQL Server 2008 T-SQL (SS2K8) Curious thought on how to approach making a query like this "better' RE: Curious thought on how to approach making a query like this "better'

  • Of course I know NOLOCK/READUNCOMMITTED is the same thing 🙂 I wasn't meaning to say that ALL locking happens in the vendors app, I was meaning to say that they attempt to control it within their app - I realize SQL Server does a really good job at handling/escalating locks all by itself, and should be left to do so.

    Yes, users are okay with the limitations of the reporting model - I fought for the removal of the locking hints, I lost.

    Thanks for the link Sean, I'll keep them handy the next time someone complains about their reports being wrong and I can use it as additional ammo for the "I told you so" conversation.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience