"." versus servename or IP

Last post 10-08-2008 3:48 PM by Luis Martin. 2 replies.
Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 10-06-2008 5:10 PM

    "." versus servename or IP

     1) Using remote administrator to access one server.

    2) Query Analyzer to reach local server and running the same query.

    a) With IP, 20 seconds.

    b) With Servername, 20 seconds.

    c) With ".", 35 seconds.

     

    Some time ago I remember why,  now I can't.

    Beside Alzheimer jokes, anyone can help me?


     

     

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    When the power of love overcomes the love of the power, the world will know peace.

    J. Hendrix


    All postings are provided “AS IS” with no warranties for accuracy.
  • 10-07-2008 2:59 AM In reply to

    Re: "." versus servename or IP

    There's something called a reverse DNS lookup if you supply an IP address instead of a resource name.

    Using just the period, of course you're connecting to the default local instance, but I assume DNS comes into play for that as well. And usually local instances are not on a fixed IP address.

  • 10-08-2008 3:48 PM In reply to

    Re: "." versus servename or IP

    Thanks Adrian!.
    Luis Martin
    Moderator
    SQL-Server-Performance.com

    When the power of love overcomes the love of the power, the world will know peace.

    J. Hendrix


    All postings are provided “AS IS” with no warranties for accuracy.
Page 1 of 1 (3 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.