insert into linked server problem

[kuNDze]

hi,

on localServer i execute this query

INSERT INTO table (A, B, C)
SELECT A, B, C FROM LinkedServer.my DB.dbo.table

everything is fine. But if i execute this one

INSERT INTO LinkedServer.my DB.dbo.table (A, B, C)
SELECT A, B, C FROM table

it is very slow. Is there any solution to make it any faster?

[AlterEgo]

Re: insert into linked server problem

kundze,

Distributed transactions across servers are substantially slower than
similar transactions executed on the same server. Assuming your servers are
both SQL Servers with the same collation settings, turn on the "Collation
Compatible" parameter in the Server Options tab of the Linked Server
Properties dialog. This could help somewhat.

Have you checked the other common performance issues such as indexes, etc.?

-- Bill


"kuNDze" <kundze@gmail.c omwrote in message
news:1173171140 .944958.149290@ p10g2000cwp.goo glegroups.com.. .

hi,
>
on localServer i execute this query
>
INSERT INTO table (A, B, C)
SELECT A, B, C FROM LinkedServer.my DB.dbo.table
>
everything is fine. But if i execute this one
>
INSERT INTO LinkedServer.my DB.dbo.table (A, B, C)
SELECT A, B, C FROM table
>
it is very slow. Is there any solution to make it any faster?
>

[Ed Murphy]

Re: insert into linked server problem

kuNDze wrote:

on localServer i execute this query
>
INSERT INTO table (A, B, C)
SELECT A, B, C FROM LinkedServer.my DB.dbo.table
>
everything is fine. But if i execute this one
>
INSERT INTO LinkedServer.my DB.dbo.table (A, B, C)
SELECT A, B, C FROM table
>
it is very slow. Is there any solution to make it any faster?

If you get on LinkedServer and execute this query:

INSERT INTO table (A, B, C)
SELECT A, B, C FROM localServer.myD B.dbo.table

is it also slow? Also, if you execute these queries:

INSERT INTO table2 (A, B, C)
SELECT A, B, C FROM localServer.myD B.dbo.table

INSERT INTO table (A, B, C)
SELECT A, B, C from table2

is the second one slow?