Four part naming

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  November 11, 2004 at 9:00 am

  #87049

  Q.  Why should a local cross database query run around 90 times slower using 4 part naming?

  e.g.  insert into server1.database1.dbo.table1  c1,c2,c3 .......    select c1,c2,c3 ..... from server1.database2.dbo.table2

  Initially running as a dts but tested the same in QA with same results

  thanks.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 11, 2004 at 12:15 pm

  #529816

  When you use the servername it thinks it is a linked server and will make a trip to find it. If you are on the same server three part names are all you require.

  Wes