I tried this in the past, but didn't have any luck.Is it possible to create a temp table on a remote server?Situation:I have to run a group of queries against a remote server.The first query is a ...

In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.