What I typically do is execute a pass-through style query on the remote server using EXEC ('..') AT REMOVE_SERVER syntax and output the result into a temp table, which I then join with my local query. It's not necessary to bring across the entire remote table, of course one only needs specific columns and the remote resultset can be filtered by date, category, client, etc.