Home Forums SQL Server 2008 SQL Server 2008 Administration ARITHABORT, default settings and slow queries RE: ARITHABORT, default settings and slow queries
Paul White
SSC Guru
Points: 150467
More actions
June 30, 2011 at 10:45 am
#1346659
Yes different plans have to be cached for different SET options (see is_cache_key in sys.dm_exec_plan_attributes) because they can produce different results, as you've seen 🙂
Paul WhiteSQLPerformance.comSQLkiwi blog@SQL_Kiwi