title: Difference between Nested loop join and hash join in SQL Server 2008
body: <p>What is the primary difference between a nested loop join and a hash join? I dont have any idea about this and all I know is that they appear on the execution plan of a query. Can anyone shed some light on this?</p>