title: Use SET ARITHABORT ON in stored procedure
body: <p>I am using a SQL Azure database.</p>
  
  <p>When I pull records,it is faster in SQL SERVER management studio. but the same query is running slow on winfrom app.I always use  stored procedure for SQL operations. </p>
  
  <p>my Stored procedure typically like this</p>
  
  <pre><code> ALTER PROCEDURE [dbo].[sp_SELECT_WorkFlow_Status_Filter]
      @Division                TINYINT,
      @IsdeptIDSelected        BIT ,
      @IsMachineStatusSelected BIT ,
      @IsPrioritySelected      BIT ,
      @DeptID                  NVARCHAR (20) ,
      @Priority                NVARCHAR (10) ,
      @Status                  NVARCHAR (20)
   AS
  
  SET NOCOUNT ON
  
  SET ARITHABORT ON -- USE HERE ????
  
  BEGIN
    ---SELECT SQL
    -----
    -----
    --RETURN RESULTS
  END
  </code></pre>
  
  <p>So if i use <code>SET ARITHABORT ON</code> something like this , will get performance as SSMS in winfroms?</p>