SQL Server Performance

Views/Storedprocedure performance

Discussion in 'Performance Tuning for DBAs' started by alpossp, Jun 20, 2005.

  1. alpossp New Member

    In SQL2000 are views optimized like stored procedures. or are stored procedures strill the way to go?
    alpossp, Jun 20, 2005
    #2

  2. satya Moderator

    Yes, SPs are absolute for performance when you've a code to execute on regular basis.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Jun 20, 2005
    #2

  3. dineshasanka Moderator

    dineshasanka, Jun 20, 2005
    #2

  4. ranjitjain New Member

    ranjitjain, Jun 20, 2005
    #2

  5. FrankKalis Moderator

    I think, you are comparing apples to peaches. These are different concepts and each one has its own legitimation. Check the articles mentioned and read thoroughfully through BOL. This should help. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
    FrankKalis, Jun 21, 2005
    #2

  6. satya Moderator

    satya, Jun 21, 2005
    #2

  7. FrankKalis Moderator

    FrankKalis, Jun 21, 2005
    #2

  8. satya Moderator

    satya, Jun 21, 2005
    #2

  9. Adriaan New Member

    Frank, nothing wrong - but it's apples and <i>oranges</i> in English. In Dutch it's apples and <i>pears</i> - what is it in German: Aepfel und Pfannkuchen?[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
    Adriaan, Jun 21, 2005
    #2

  10. FrankKalis Moderator

    Still remembering it? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />] No, in German it's "Äpfel und Birnen". So, same as in your language. <br /><br />At least it caused some fun [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
    FrankKalis, Jun 21, 2005
    #2

  11. dineshasanka Moderator

    quote:Originally posted by FrankKalis

    I think, you are comparing apples to peaches.

    Nice one
    dineshasanka, Jun 21, 2005
    #2

  12. ranjitjain New Member

    Well can we say like this tooo that <br />he is trying to compare males to females.[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />I think, you are comparing apples to peaches. These are different concepts and each one has its own legitimation[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterst?ASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
    ranjitjain, Jun 21, 2005
    #2

  13. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />he is trying to compare males to females<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />I am very curious on the results here [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
    FrankKalis, Jun 22, 2005
    #2

Share This Page