In SQL2000 are views optimized like stored procedures. or are stored procedures strill the way to go?
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.
check this article too....why we should use sp http://www.sql-server-performance.com/gv_sp_views_selects.asp
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 />
LOL Frank's comparison is good[8D] 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.
Was it wrong? I thought I could say so [?] -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Not at all, it gives a lighter side of topic. 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.
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='' />]
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='' />]<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 />
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='' />]<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">
<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 />