Lynn Pettis (7/21/2014)
Issues.Three, and I may be wrong here, but you are going to be pulling the data from all the tables referenced across your network to the server running the query where the respective joins and filtering will then be completed.
That is the way it appears to me as well. That is a recipe for problems.
Far more efficient to perform the join query on the remote server and then pull the resultant data across if you truly must pull it across to a different server.
That can be done in many different ways. In the end, just join the data on the source server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events