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.
Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To ...