title: Improve query performance when joining on a linked server table
body: <p>Unfortunately as a temporary measure whilst we fix our datacentre I need to run the following cross server query, can anyone suggest how I can get the performance to increase...</p>
  
  <p>as have to run this statement at the start of a cursor</p>
  
  <pre><code>SELECT t.SearchId, t.VisitSourceId, t.SiteDomainId, t.trpUTMid, t.FlightPlus, t.StartDate,
  t.CountryId, t.ProvinceId, t.Locationid, t.PlaceId, t.EstabId, t.CheckInDate, 
  t.CheckOutDate, t.Rooms, t.Room1Adults, t.Room1Children, t.Room2Adults, t.Room2Children, 
  t.Room3Adults, t.Room3Children, tc.OutcomeDate, tc.OutcomeId, tc.HotelsFound, tc.Notes
  
  FROM [MLT_VisitTracking].[dbo].TrackingAcomSearches_tbl t
  INNER JOIN TrackingAcomSearchesOutcome_tbl tc
  ON t.trpUTMid = tc.trpUTMid
  LEFT JOIN [YAZOO].[MLT_VisitTracking].[dbo].TrackingAcomSearches_tbl tid
  ON t.trpUTMid = tid.trpUTMid
  WHERE tid.trpUTMid IS NULL
  </code></pre>