MS SQL Server Connectivity - Local Remote server......

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Local Remote server......

len

2005-06-21, 7:23 am

Hi there.

I was just wondering... Using T-SQL, is there any performance difference in
referencing the local server using it's full qualifier?

Example: On a server "MyServer", is there any potential difference in
performance in running the following two queries:

SELECT * FROM MyDatabase.dbo.MyTable
and
SELECT * FROM MyServer.MyDatabase.dbo.MyTable

Basically, I want to write an app that can be configured to run queries
locally or on some remote server and I just want to be sure there are no
unnecessary communication layers utilised if I use the full qualification for
my local server....

Any info would be appreciated!!

Sponsored Links