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?
  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.
  3. dineshasanka Moderator

  4. ranjitjain New Member

  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 />
  6. satya Moderator

  7. FrankKalis Moderator

  8. satya Moderator

  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=':)' />]
  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 />
  11. dineshasanka Moderator

    quote:Originally posted by FrankKalis

    I think, you are comparing apples to peaches.

    Nice one
  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">
  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 />

Share This Page