How I Optimized a Painfully Slow Cross-Server Join

I had a simple requirement. Pull data from Server 1.Join it with a table in Server 2.Return the result. Simple on paper. Painfully slow in reality. The cross-server join was taking an unacceptable amo