hi Matt,

As per my understanding, the effect of Isolation level on the database engine was not reflecting. As I manually once set the TRANSACTION ISOLATION LEVEL to READ COMMITTED (which...

I have tested the DB by taking the backup of the DB in my local machine, which is having the capacity of 1 physical processor, and 1 GB of RAM....

Yes I have 4 Servers. The query execution plans are same for both the environments. The number of articles are huge in this case.

I can't see any other reason...

Yes, this is always possible. Use SQL Server Security for the same. You can give the access of the database only to the current user. You just need to map...