Posted by AlterEgo on 03/06/07 17:22

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.com> wrote in message
news:1173171140.944958.149290@p10g2000cwp.googlegroups.com...
> 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?
>

• Next in forum: Re: Access and SQL Server Speed Comparison
• Prev in forum: Re: how to recompile / refresh UDFs ?
• Thread view: Re: insert into linked server problem

[Reply to this message]