hi,

on localServer i execute this query

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

everything is fine. But if i execute this one

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

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

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 (AT) gmail (DOT) com> wrote

kuNDze wrote:

If you get on LinkedServer and execute this query:

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

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

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

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

is the second one slow?