Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

White Papers

Posted Apr 6, 2010

Upgrading to SQL Server 2008 for Better Performance

By DatabaseJournal.com Staff

Migrating to a new version of SQL Server should not be based on the desire to be on new technology.  Instead, you should base it on business requirements.   Migrations are costly therefore you want to make sure you get some value for the effort you spend migrating your application.   SQL Server 2008 comes with a number of new features.  If you need these new features then migrating to SQL Server 2008, make sense.

There are a number of different features in SQL Server 2008 that you might be able to leverage to identify value for your migration effort.  Here are a few of those features:

·         Data compression

·         Policy based management

·         Improved database mirroring

·         Data collector

·         Resource governor

·         Transparent data encryption

These features can be used to save on disk space, throttle CPU and memory resources, control your different environments consistently, provide a more secure environment for your data, and allow you to monitor and improve performance.

Migrating to SQL Server 2008 is much easier than past migrations.  SQL Server 2008 has been out for quite a while now, so there is no question it is stable.  If you couple stability with other cost savings features, improved management functionality, and performance enhancements then SQL Server 2008 appears to have a number value add features that older releases do not.  By reading this white paper, you will understand more about the new features of SQL Server 2008 that can help your organization and justify the value of migrating to SQL Server 2008. 

View Article

White Papers Archives