1. tonyliu322 New Member

   the database is only used for reporting purpose, and there are lots of query (select) run again the database, just wonder if the WITH (NOLOCK) statement would help improving the performance?
   thanks
   

   tonyliu322, Jan 16, 2008

   #2
2. martins New Member

   Yes it could definitely improve performance. I would suggest that you add it to the queries.
   

   martins, Jan 16, 2008

   #3
3. Madhivanan Moderator

   Duplicate o0f http://sql-server-performance.com/Community/forums/t/25156.aspx
   

   Madhivanan, Jan 16, 2008

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in