Most important reason to convert now?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Most important reason to convert now?

  1. #1
    kirbyt Guest

    Most important reason to convert now?


    What is the most important new feature in SQL Server 2000 that would entice
    a developer to move from the 7.0 version? Somethings just work and often
    best to NOT continue running the 'upgrade' path. It's not always a NIKE
    commercial.

    And is the new book applicable to people buying it but still running the
    7.0 version?
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Most important reason to convert now?

    Most important, eh? Well, that's tough because it's going to vary by
    situation.

    My personal vote is for User Defined Functions. They allow you to do some
    degree of sproc like actions inline to a SELECT statement. You can even have
    your UDF return a table, in which case you can join to the results much as
    you would a derived table.

    Other candidates would include the new IDENTITY functions (that allow much
    closer scoping of identity values), Indexed Views (which can have some
    killer performance impacts, but is, unfortunately, only available in the
    Enterprise Edition).

    As for the new version of the book - I try and note backward compatibility
    issues, but I would still recommend the 7.0 book for people who expect to
    remain using 7.0 for any length of time.


    --
    Rob Vieira MCSD, MCT, MCDBA
    www.ProfessionalSQL.com

    "kirbyt" <kirby_thomson@anadarko.com> wrote in message
    news:3a6c9e8f$1@news.devx.com...
    >
    > What is the most important new feature in SQL Server 2000 that would

    entice
    > a developer to move from the 7.0 version? Somethings just work and often
    > best to NOT continue running the 'upgrade' path. It's not always a NIKE
    > commercial.
    >
    > And is the new book applicable to people buying it but still running the
    > 7.0 version?



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center