A useful list of tips if you are using SQL Server's linked server functionality:
http://www.sql-server-performance.com/linked_server.asp