Sometimes the SQL Server query optimizer does not pick the best index to use in a join operation. This can be caused by a multitude of factors (out of date statistics, wrong indexing strategy for a table, etc) ... for what ever reason it happens, there...