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@xxxxxxxxx> wrote in message
news:1173171140.944958.149290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Return Code from Win32_Processs Create method
    ... > servers, so I can't use Win32_ProcessStopTrace class, as mentioned in ... > Dim objWMIService, intProcessID, intReturnCode ... > ' /* WMI Binding okay, so now execute the process ... > Wscript.Echo "WMI Binding Error: Process execution could not occurs due to ...
    (microsoft.public.scripting.vbscript)
  • Re: Execute permission denied on object xp_SQLagent_notify
    ... On my server the xp_sqlagent* stored procedures are granted execute to ... The account is public in master and db_owner in msdb. ... same settings on 10 servers. ... EXECUTE permission denied on object 'xp_sqlagent_is_starting', ...
    (microsoft.public.sqlserver.security)
  • RE: DBD::Oracle and ORA-600 [16365] errors
    ... > programand execute them in the same manner as an on-line ... Basically, the database would run out of servers and fail, and there was ... So, MTS was the ideal solution, apart from this crash issue:-/ ...
    (perl.dbi.users)
  • Could corrupt data cause Error #7643 ("Too many results") ??
    ... I'm trying to execute this search on a table containing approx 80K records ... versions of SQL & OS and do not get the error on them. ... the Noise Word files for all of these servers are empty. ...
    (microsoft.public.sqlserver.fulltext)
  • Dont Understand login script location..
    ... created a login script under the "Default domain policy" OU, ... the servers, but how do you get it to execute on w98 systems, the following ...
    (microsoft.public.windows.server.scripting)