IT Dimensions
"In 2006, 161 exabytes of digitalinformation were created, representing roughly 3 million times the information in all the books ever written."

SQL Server 2005 vs SQL Server 2008

PROS - SQL Server 2005 PROS - SQL Server 2008
Mature product with most of the potential issues addressed Longer support and longer time before moving to newer version.
Implementation path will be easier New features such as geospatial indexing that are not available in 2005
Window for stabilization, tuning and removing legacy code  
More skilled people with SQL Server 2005  
CONS - SQL Server 2005 CONS - SQL Server 2008
58-80% repeated effort (process is reused but testing effort doesn't change) Major changes for both DBA and developers
Two downtime windows More intensive testing required because of deprecated features
Lacks latest capabilities More downtime because of the above
  Many bugs are not discovered. Longer wait time for the corresponding packs or hotfixes.

© 2015 IT Dimensions, Inc. All Rights Reserved.
Call us: 1-718-777-3710 | Astoria | New York
Data Quality