I've run into another interesting problem when running this query in our production environment.

We have 2 servers S1 and S2. S1 is our production OLTP server, S2 is our production...

I've identified the mechanism that is causing the extrememly slow query times. It turns out that doing a join between a table on a linked server and local table causes...