merge join with remote table takes 1 hour
2015-07-11 19:48:51
Remote query on linked server is 100 precent of costs and runs for 1 hour