
Query slow over liked server
Hi,
I have a problem with a query runing on a linked server.
When I execute the following on the target server the query takes about 2
secs
UPDATE TableName
SET MarkedForXfer = 0
WHERE MarkedForXfer = 1
When I execute the following on a linked server from another server the
query takes about 30 mins
UPDATE SQLLinkedServer.Database.dbo.TableName
SET MarkedForXfer = 0
WHERE MarkedForXfer = 1
Has anyone got any Ideas why this would be?
Thanks
Devron