SQL Server Performance

WITH (NOLOCK) statement

Discussion in 'T-SQL Performance Tuning for Developers' started by tonyliu322, Jan 16, 2008.

  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
  2. martins New Member

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

Share This Page