title: Does a long-running query prevent an insert to tables involved?
body: <p>Say I have two tables:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>Table 1
  [Clustered Id]    [Text Field]
  
  Table 2
  [Clustered Id]    [Numeric Field]
  </code></pre>
  
  <p>Then I have a query:</p>
  
  <pre class="lang-none prettyprint-override"><code>select *
    from [Table 1]
        ,[Table 2]
   where [Table 1].[Clustered Id] = [Table 2].[Clustered Id]
     and [Table 1].[Text Field] like '%some string%'
  </code></pre>
  
  <p>Say my insert inserts one row, and looks like this:</p>
  
  <pre class="lang-none prettyprint-override"><code>insert into [Table 2]
  values (new clustered ID)
        ,-182
  </code></pre>
  
  <p>If this query takes a long time to run, would an insert to <code>[Table 2]</code> be possible during that time? If so, what are the nuances? If not, what could I do to avoid it?</p>