Today, more than 4,700 Microsoft® SQL Server® 2008 instances with about 100,000 databases on dedicated hosts support 1,300 applications across several teams in Microsoft Information Technology (Microsoft IT). Because it has deployed SQL Server 2008 since early beta, Microsoft IT has had time to assess and report the top 10 features of the product in its environment.

Download

Download Article, 116 KB, Microsoft Word file

Following are 10 key reasons why Microsoft IT is excited about the enhancements in SQL Server 2008.

1. Row Data Compression

2. Page-Level Data Compression

3. SQL Server Integration Services

4. Multidimensional Expressions

5. Resource Governor

6. Star Join

7. Change Data Capture

8. MERGE Operator

9. Transparent Data Encryption

10. Database Mirroring

To view the entire article click here.