Thank you very much everybody, i will try all suggestions and let you know what happens

Thanks for your reply, Well i did exactly the same thing on my local machine and it was fine.

but if i will do that on my Production Server, wouldnt that...

Well I can only move TEMPDB database point to a different drive only if i am on a single user mode right?

The instance on which i want to perform this...

Thanks for the reply, but i am able to do that, sqlcmd works fine for me.

does this mean that i have to type "sqlservr.exe -m" after i type in sqlcmd?

No i still cannot, i dont know why, its the same location...

Thank you very much for your reply

So does that mean we can not improve the performance of the view which is referencing objects from other servers?

To explain this better,

I have...