SQL Server query with Linked Server running without Parallelism
Joining to a table via a Linked Server is problematic.  You can workaround the issue by pulling the required rows from the remote table into a local #temp table, and JOINing against that #temp table instead.