Benefits of upgrading to SQL Server 2005

Will SQL Server 2005 offer benefits as a direct upgrade from SQL Server 2000 -- with no code changes?

    Requires Free Membership to View

An emphatic yes! Of the many benefits of upgrading to SQL Server 2005, there are many that database administrators will get for "free" -- that is, without any change to code and with minimal change to system configuration. These benefits include every DBA's favorite type of enhancement: performance optimizations. The SQL Server Engine team describes some of the optimizations made to tempdb in this blog.

Many other enhancements also come with nothing more than a simple upgrade, including many features that will help in the areas of security and manageability. Don Vilen, SQL Server Program manager for Microsoft, details some "transparent" upgrade benefits, in this archived TechNet webcast.


Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in September 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.