Use index hint and join hint...

When should I use an INNER -LOOP- JOIN instead of an INNER JOIN...

Loop Join in SQL Server 2008...

TSQL - What is the proper order to joining tables?...

INNER LOOP JOIN Failing...

SQL Server Hash Joins versus Nested Loops...

Any issues with join hints in a SQL Server 2000 view?...

SQL Server LEFT JOIN fails to match rows without JOIN hint...

Is this join hint dangerous?...

SQL Server Query Optimization Using Join Hints...

SQL SERVER 2008 JOIN hints...

T-SQL - why INNER MERGE JOIN makes several joins definitons to executed more faster...

advantages in specifying HASH JOIN over just doing a JOIN?...