IT Dimensions
"On average, the size of transactional databases doubles every five years with core databases doubling every two years. Data reporting and analysis warehouses (OLAP stores) triple in size every three years."

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