Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp How to join a local table to a remote table by way of a linked server RE: How to join a local table to a remote table by way of a linked server
sherifffruitfly
Ten Centuries
Points: 1198
More actions
February 27, 2012 at 8:19 am
#1452093
When I require live data, I almost always join against OPENQUERY resultsets - much, much, MUCH faster than directly joining to the remote server.
Or else an SSIS job.
-sff