title: SQL Server ARITHABORT
body: <p>I'm working with a client who has just upgraded from SQL 2000 to SQL 2008 and their view query times have gone up a lot.</p>
  
  <p>I had a look at the views and couldn't see much wrong with them. When I ran the view directly on the server, the times were OK. When I ran via Management Studio remotely, the time goes from 2secs to about 30secs.</p>
  
  <p>So, I've tried an experiment on the test copy by setting ARITHABORT to ON (based on some articles), and the times go down remotely as well.</p>
  
  <p>So, setting ARITHABORT seems to be the answer, but before applying to the live DB, I'd like to understand why. I get that it's to do with the level of severity of a zero divide, but why should it help with view query times?</p>