title: How to avoid Sql Query Timeout
body: <p>I have RO access on a SQL View. This query below times out. How to avoid this?</p>
  <pre><code>select  
    count(distinct Status)  
  from 
    [MyTable]  with (NOLOCK)
  where 
    MemberType=6
  </code></pre>
  <p>The error message I get is:</p>
  <blockquote>
  <p>Msg 121, Level 20, State 0, Line 0</p>
  <p>A transport-level error has occurred when receiving results from the server (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)</p>
  </blockquote>