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.

A private preview of SQL Server 2025 began in November 2024, followed by a public preview in May 2025. Now, it is time for the natural next step, as the tool has received its first release candidate, ...