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...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/kba/archive/2007/10/24/2579.aspx