Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server
The following pages were recently modified.
Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition
Notification Contents: New and Major Modifications
Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server
http://support.microsoft.com/kb/942982/en-US