Q

Benefits of upgrading to SQL Server 2005

SQL Server 2005 expert Adam Machanic discusses the 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?

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

Dig deeper on Microsoft SQL Server 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close