title: Does delete with join lock the table that is *not* being deleted from?
body: <p>If my query looks like:</p>
  
  <pre><code>DELETE a
  FROM TableA AS a
  JOIN TableB as b
  ON a.SomeColumn = b.SomeColumn
  </code></pre>
  
  <p>is <code>TableB</code> locked for the duration that it takes to delete all the records from <code>TableA</code>, or not? If it is, is it a table-level, page-level, or row-level locking?</p>
  
  <p>I'm using SQL Server 2008 R2, and I'm having a hard time finding good information about when and how SQL Server uses locking in general, so any resources related to that would be much appreciated. </p>