When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?
Some results have been hidden because they may be inaccessible to you
Show inaccessible results