title: SQL Server linked server performance
body: <p>I am using SQL Server 2008 Enterprise. And I am using Linked Server technologies to link another SQL Server 2008 Enterprise instance from another server. I write TSQL to manipulate objects (e.g. tables) from both server instances.</p>
  
  <p>My question is, for linked server, is there a big performance issue? If yes, what is the key performance bottleneck and best practice we should follow?</p>
  
  <p>thanks in advance,
  George</p>