title: Slow performance of SqlDataReader
body: <p>I've query executing ~2 secs in MSSMS (returning 25K of rows)</p>
  
  <p>Same query used in .NET (sqlReader) exetuting few minutes!</p>
  
  <p>I've also tried to execute only reader </p>
  
  <p>(commented all code in while loop just leaving reader.Read() ) - still same!</p>
  
  <p>Any idea what's up?</p>
  
  <hr>
  
  <p>I'm not DBA and not priviledged to play with Profiler - will ask my DBA and let all know.</p>
  
  <p>In the meantime I'm noticed essential performance boost after adding "<strong>WITH RECOMPILE</strong>" param to SP I'm talking</p>
  
  <p>So, from my perspective it seems to be the case with execution plan...
  What do you think?</p>
  
  <p><strong>[EDIT]</strong>
  Also what I've checked was performing below query from QA and .NET</p>
  
  <pre><code>select @@options
  </code></pre>
  
  <p>My understanding is it shall return same value for both environements.
  (If not differnet ex.plans will be used)
  Am I right?</p>
  
  <p><strong>[EDIT2]</strong>
  I've read (from <a href="http://www.sqldev.net/misc/fn_setopts.htm" rel="noreferrer">http://www.sqldev.net/misc/fn_setopts.htm</a>) that <strong>ARITHABOIRT</strong>=ON in QA (in .NET it is off)</p>
  
  <p>Does enybody know how to force ARITHABOIRT=ON for every .NET connections?</p>