Has anybody worked with SQL 2000 systems where majority of the SELECT statements had been forced to have WITH (NOLOCK) in them? All statements look like Select * from Table1 WITH (nolock). We know that we get the dirty reads but we avoid blocking of the data this way. We suspect, that using (NOLOCK) turns off the SQL LOCK MANAGER and we get the TABLE LOCK level on all our SELECT queries. We do not see a lot of blocking just some, but still does anybody know about any other affects on the SQL performance or have any opinion on the use of the WITH (NOLOCK) in the SELECT statement when working with the tables which heavily used to read from and write to?