title: When should I use an INNER -LOOP- JOIN instead of an INNER JOIN
body: <p>Today I learned about a thing in SQL Server called <a href="https://stackoverflow.com/questions/6528906/why-is-this-an-index-scan-and-not-a-index-seek"><code>INNER LOOP JOIN</code></a>.</p>
  
  <p>What does this mean? (Google is not helping .. or should I say ... the blog posts about it are a bit .. technical and are blowing my mind).</p>
  
  <p>Also, what are some common scenarios that would be a good idea to use an <code>INNER LOOP JOIN</code> over a standard <code>INNER JOIN</code>?</p>