SQL Server Performance Forum – Threads Archive

ANSI Settings Performance Implications

Hi All, I have read in the documentation and other books of SQL Server about the ANSI Settings that are availabe in SQL Server. No doubt these settings change the way the query is executed. But I want to know as to what is the performance implications of these settings being OFF or ON[?] Any link to resources enlighting this topics is appreciated. [<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />] Thanks, Gaurav

Not sure about performance implications, but worth referring this link http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci864562,00.html]. HTH _________
Satya SKJ

I haven’t seen any good data on this, nor have I done any experimentation myself. I would also be interested in seeing such results. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com

Thanks Satya for the link. This topic talks about setting the ANSI settings within a stored procedure. Definately this was iformative. I’ll keep this in mind. But this still leaves my question unanswered. Any further help is appreciated… Gaurav

I echo Brad’s comments in this regard, I too never had any issues until now in my experience. _________
Satya SKJ

]]>