title: SQL: Locking on temp tables
body: <p>Are locks taken out when querying a temp table? If so, how granular are they by default? Is there a performance hit similar to locking normal rows/table?</p>
  
  <p>I assume no locks are taken because temp tables (at least as of SQL 2008) are created per instance.</p>
  
  <pre><code>select x,y,z into #MyTempTable
  from SomeOtherTable
  </code></pre>