Stack Overflow
Stack Overflow

Questions tagged [arithabort]

Use this tag for questions related to ARITHABORT, which terminates a query when an overflow or divide-by-zero error occurs during query execution.

should always be set to ON in your logon sessions. Setting to OFF can negatively impact query optimization leading to performance issues, as discussed in SET ARITHABORT (Transact-SQL).

This tag is usually accompanied by and alike tags, so please, consider using them, if relevant.

14 questions
51
votes
8 answers

Query times out when executed from web, but super-fast when executed from SSMS

I'm trying to debug the source of a SQL timeout in a web application that I maintain. I have the source code of the C# code behind, so I know exactly what code is running. I have debugged the application right down to the line that executes the…
Michael Bray
  • 14,998
  • 7
  • 42
  • 68
4
votes
1 answer

controlling ArithAbort in EF4

We are having some performance issues with our EF4 MVC solution. We've been able to track it down to ArithAbort getting set to off before all connections to the database, and now we are trying to force it to stay as 'ON'. We've looked at: How do you…
Grubsnik
  • 918
  • 9
  • 25
3
votes
2 answers

ARITHABORT OFF adversely affecting performance

I am fully aware that SQL Queries from applications typically use SET ARITHBAORT OFF where as SSMS (by default) uses SET ARITHBAORT ON. I also believe that SET ARITHBAORT OFF is only there for legacy compatibility and really queries should be run…
Chris Walsh
  • 3,423
  • 2
  • 42
  • 62
3
votes
1 answer

How to SET ARITHABORT ON for connections in Linq To SQL

By default, the SQL connection option ARITHABORT is OFF for OLEDB connections, which I assume Linq To SQL is using. However I need it to be ON. The reason is that my DB contains some indexed views, and any insert/update/delete operations against…
Laurence
  • 980
  • 12
  • 31
0
votes
1 answer

Set ARITHABORT On only fail in asp

I have this error message : SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or…
GregM
  • 2,634
  • 3
  • 22
  • 37
0
votes
0 answers

PowerBuilder Script to set ARITHABORT ON/OFF

How to set ARITHABORT (SessionProperty in SQL server) in PowerBuilder script? While opening an application (which is created in PB) I want to set ARITHABORT ON/OFF. Please help...With your answers
keerthana keerthi
  • 1
  • 1
0
votes
1 answer

In SQL Server, always activate Arithabort, recommended?

I have had this doubt for a long time and no matter how much I read and search for information I can't find anything clear. For example, this web site recommends it:…
supercrash10
  • 73
  • 1
  • 5
0
votes
1 answer

Should i set ARITHABORT ON in all SELECT queries in an application

I have faced a sudden performance-drop issue in a VB6 (ADO/ODBC to SQL Server) application i'm maintaining which seems to be solved by adding SET ARITHABORT ON before some SELECT queries. The questions are: Would it be wise to create a generic…
FaultyOverflow
  • 153
  • 1
  • 9
0
votes
1 answer

How to use ARITHABORT in a view?

I've got a view which is working very fast in SSMS (MS Sql Server) but working really slow in my web app. My ARITHABORT setting in the database is set to ON but I'm unsure whether this continues through to the web app. Is there any way to set this…
user25730
  • 517
  • 2
  • 6
  • 24
0
votes
1 answer

SSRS giving me an error but the query works perfectly in SSMS

My query that i have been working on for quite some time finally works. I have been working on it to implement it into a SSRS report. However when attempting to copy paste the query into a dataset i receive the following error : SELECT failed…
Azuraith
  • 1,030
  • 14
  • 28
0
votes
1 answer

Failed because incorrect arithabort setting

I created a unique index (case description should be unique if IsDelete != 1) CREATE UNIQUE NONCLUSTERED INDEX [UniqueCaseDescription] ON [tblCases] ([fldCaseDescription] ASC) WHERE [IsDeleted] = CAST(0 AS varbinary(1)) WITH (PAD_INDEX = OFF,…
Kate
  • 1,495
  • 4
  • 21
  • 35
0
votes
1 answer

Fail to update datum in sql server - arithabort error

in an vb.net project, I hardly managed to fix every insert / update queries cause of the arithabort problems I encountered and now, my project works well for me, yesterday, by deploying the application on another server (windows 2003 R2 SP2), I…
romulus001
  • 318
  • 3
  • 15
0
votes
0 answers

SQL Server ARITHABORT setting

Where is the best place to set ARITHABORT ON? In Db or in App? MSDN says to turn on in logon session. If we have to turn on every logon session, why I cannot turn on in DB instead of turning on in every logon session.
Ant
  • 3,369
  • 5
  • 25
  • 23
-1
votes
1 answer

SET ARITHABORT ON doesn't avoid error on Insert

We have a stored procedure that inserts into a staging table with a computed column. The proc is called from bcp and is throwing an error because ARITHABORT is disabled at the Database level. I added SET ARITHABORT ON at the beginning of the proc,…
alerancur
  • 1
  • 3