Home Forums SQL Server 2005 T-SQL (SS2K5) SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK) RE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK)

  • December 19, 2008 at 4:41 am

    #915111

    out of curiosity, from a performance point of view, which is better:

    setting WITH(NoLock) on every table or setting the isolation level (if different from Read Uncommited) at the start of each session?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie