SQL Server Performance

Procedure Variable

Discussion in 'SQL Server 2005 General Developer Questions' started by Madhivanan, Oct 20, 2005.

  1. Madhivanan Moderator

    I am interested to know whether SQL Server 2005 supports Procedure Variable and View Variable similar to that of Table Variable used in SQL Server 2000

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Oct 20, 2005
    #2

  2. Madhivanan Moderator

    No answers

    Well. Where do I find the major differences between SQL Server 2000 and 2005?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Oct 24, 2005
    #2

  3. FrankKalis Moderator

    FrankKalis, Oct 24, 2005
    #2

  4. Madhivanan Moderator

    Thanks Frank<br /><br />&gt;&gt;Frankly, I don't know the answer.<br /><br />Frank, I Frankly say "It is Frank that you say everything Frankly" [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
    Madhivanan, Oct 24, 2005
    #2

  5. FrankKalis Moderator

    [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<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, Oct 24, 2005
    #2

  6. satya Moderator

    You must have SQL 2005 CTP installed to have the 2005 books online, so take your chances.

    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, Oct 24, 2005
    #2

  7. FrankKalis Moderator

    FrankKalis, Oct 24, 2005
    #2

  8. satya Moderator

    That is essential, but still few links and subjects will not work until you have the CTP installed.
    I tried on my project laptop exclusively BOL but without CTP it couldn't work.

    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, Oct 24, 2005
    #2

  9. ramasubbup New Member

    Short summary of some new stuff

    TSQL
    Common Table expression
    Really useful for handling Tree like Data structure
    Navigate top down, Bottom up, Stop at some level, get the node information..etc
    ROWNum
    Ranking/Dense Rank funtions
    Pivot/Unpivot
    Very good to pivot and unpivot the data ( as we use in excel)

    OUTPUT command in UPDATE/DELETE statements
    Used to store old and new data. Same like deleted and inserted tables
    we use in trigger to hold old and new data
    But, there is a limitation, If you Update Huge volume,the system goes for a toss.


    Service Broker
    Used for messaging,queue..etc

    .net Integration
    Very good one.
    Create funtions, datatypes, procedures in .net and use in YUKON
    Simple steps..create assembly in .net, Import assembly in YUKON , use it..

    XML
    Store your xml data as a column, query it, Use in where clause..etc

    Database Mirroring

    Templates
    ramasubbup, Dec 12, 2005
    #2

  10. ramasubbup New Member


    Some more to add....

    Snapshot Isolation
    Two updates at the same time to same data...

    Non Clustered Indexes
    I heard that apart from columns which we use for indexing,
    you can store other columns also along with the index keys,
    But they will not be part of the index..
    I may be wrong..but has to verify.

    ramasubbup, Dec 12, 2005
    #2

  11. Madhivanan Moderator

    Thanks for the information [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
    Madhivanan, Dec 12, 2005
    #2

Share This Page