Use SET ARITHABORT ON in stored procedure
<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>