Ars Technica

SQL Server - Linked Servers going back 3 layers - how does query execution work?

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.