title: Create local Linked Server using Server Name or IP Address?
body: <p>Based on the answer I received on this question (<a href="https://stackoverflow.com/questions/1911969/most-efficient-way-to-select-records-in-one-database-based-on-result-set-from-tot">https://stackoverflow.com/questions/1911969/...</a>) I have set up a Linked Server on SQL Server 2008 to a Pervasive database.</p>
  
  <p>Since both databases are on the same physical server, what would be the recommended method to create the linked server, using the IP Address of the server or the Server Name?  My gut tells me to use the IP address as to avoid resolving the name and avoid any unnecessary lookups.  Or does it really not matter at all speed wise?</p>
  
  <p>What do you think and why?</p>