Post reply

Four part naming

  • 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/

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply