Posted by Ed Murphy on 03/07/07 04:29

kuNDze wrote:

> 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?

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?

• Next in forum: Simple SQL Help
• Prev in forum: Re: Delete and update
• Thread view: Re: insert into linked server problem

[Reply to this message]