the database is 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
Kindly don't duplicate post. I've deleted the other one. If you need exclusive select (means no one can update, insert, etc.) you don't need noclock. Otherwise you can use it.
Yes. Or better yet, make the database read-only except when it is actually being modified, as that will reduce overhead even more. SELECTing on an updateable (not read-only) table still takes shared locks.