Local Remote server......

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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!!
.

Relevant Pages

  • Re: Threading enabled performance impact
    ... server, then you need the new version installe don the same server to ... Something like perl would seem perfectly benign, but it is very possible to risk running afoul of corporate policy. ... whatever performance difference might exist between the two versions is *very* helpful. ...
    (comp.lang.perl.misc)
  • Re: Internal Traffic on PC is very slow
    ... Hamster to/ fro XanaNews ... Hamster Classis is a local pop3/ nntp/ smtp/ imap server. ... download mails/ news from several accounts/ servers and combine ... in its own local server and relay them to users who access its ...
    (comp.security.firewalls)
  • Re: unable to publish to local IIS
    ... Stefan, I never had, in my local server http://My_Desktop/ a file named with ... reinstalll IIS with the front page extensions. ... To find the best Newsgroup for FrontPage support see: ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: For those that hand code...
    ... I rarely have any trouble setting up the local server to mimic the ... export the whole database from one and import it into the other. ... initial remote site from my local test site. ...
    (alt.html)
  • Re: Need a script spanning two servers suggestion.
    ... We have a local server which holds all of our image files. ... Have the PHP script on the local server which processes the files and sends the file names it processed... ... Through a GET in a WGET back to another PHP script on the remote server which pulls the database info for those filenames and creates ...
    (comp.lang.php)