Steve and Colin,

Thanks for your reply.

I am leaving in remote area of Pennsylvania where it is difficult to find out one DBA. People are coming and they don’t like the place so they are leaving very soon. My company is trying their best to hire someone at onsite. Due to HIPAA regulations, they would not be interested in remote DBA’s. So I have to try and make sure that at least basics are working fine until they find a real professional DBA.

I am looking at update statistics and re-indexing. Any other suggestions?

Thanks,

Ramesh.