• Hang the typo's!!  There aren't that many and it's very obvious what they are/should be.  Heck, I've seen more errors in published books that have supposedly been professionally proof-read and edited!

    Sureshkumar, this is an outstanding article... you cover some of the previous enhancements in previous versions, you nailed many of the big, more useful changes, and you gave examples of many of them.  Certainly, your summaries of each new feature are interesting and useful.  Without getting bogged down in unnecessary levels of detail, you even hit the UPDATE.WRITE requirement.

    I've had many people ask me to summarize some of the differences between 2000 and 2005... I'm just going to refer them to this URL from now on.  Developers making the transition to 2005 should sit down with Books OnLine and use your article as a guide of what to study in depth.  This should be required reading for all experienced Developers making the transition.

    I think you've accomplished exactly what you set out to do with this article... Thank you VERY much for taking the time to write such a great overview of some of the new functionality available... I can't wait for you to publish Part 2 and, hopefully, a Part 3.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)