15 People are following this question.
Is it a good idea to use the "remote" join hint?
Sql server conditional Join while using parameter
Using outer query tables in sub-query joins (defined in select clause)
How To Remove Hash Match/Inner Join From Execution Plan?
Is it possible to Join a query with a Count function and sort by the joined fields?