SQL Server Performance

ANSI Settings Performance Implications

Discussion in 'T-SQL Performance Tuning for Developers' started by gaurav_bindlish, Apr 1, 2003.

  1. gaurav_bindlish New Member

    Hi All,<br /><br />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[?]<br /><br />Any link to resources enlighting this topics is appreciated. [<img src='/community/emoticons/emotion-11.gif' alt='8)' />]<br /><br />Thanks,<br /><br />Gaurav
  2. satya Moderator

  3. bradmcgehee New Member

    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
  4. gaurav_bindlish New Member

    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
  5. satya Moderator

    I echo Brad's comments in this regard, I too never had any issues until now in my experience.

    _________
    Satya SKJ

Share This Page