The restore happens through a web based tool, and it happens on demand. The web app runs under dbservice user account. The account cannot be given sa privileges.

Hi Frank,

Thanks for your response.Query optimizer is indeed a smart piece of code and it comes out with an optimal plan in most cases.But as the complexity of...

Hi Antares686, thanks for your response.I am pasting a part of the query below.As you will see in all the joins I have used a loop join hint but I...