SQL 2008 Special New Features

From one of the online survey I got for SQL Server, I was able to gather below details which are the special features of SQL Server.

1. ADO.NET Data Services
2. Automatic Recovery of Data Pages
3. Backup Compression
4. Change Data Capture
5. Data Compression
6. Enhanced Database Mirroring
7. Extensible Key Management
8. Grouping Sets
9. Hot Add CPU
10. Language Integrated Query (LINQ)
11. Log Stream Compression
12. MERGE SQL Statement
13. Partitioned Table Parallelism
14. Performance Data Collection
15. Policy-Based Management
16. Predictable Query Performance
17. Resource Governor
18. SQL Server Integration Services (SSIS) Persistent Lookups
19. SQL Server Integration Services (SSIS) Pipeline Improvements
20. Star Join Query Optimizations
21. Streamlined Installation
22. Transparent Data Encryption
23. Rebuilding a Heap using ALTER TABLE Command

From the above, I have idea about Backup/Data compression, Resource Governor, Policy Based Management, Change data capture... Need to explore others...

Here it goes another online quiz from microsoft technet on SQL Server 2008 features:

What's your answers?
1. What new feature did Microsoft introduce in SQL Server 2008 from an administration point of view?
a) Hot Memory add
b) Hot CPU add
c) Both a and b
d) None (This was available in SQL Server 2005 as well)

2. How many processor licenses are required for Microsoft SQL Server 2008 running on a 2 processor server, each with 4 cores?
a) 2
b) 8
c) 4
d) 6

3. Resource Governor in Microsoft SQL Server 2008 allows users to manage which of the following resources?
a) CPU
b) Memory
c) HDD
d) Both a and b

4. Microsoft SQL Server 2008 has which of the following BI Capabilities?
a) Analysis including OLAP and Data Mining
b) ETL and Data warehousing
c) Reporting
d) All of the above

5. Which of the following is NOT a new data type in Microsoft SQL Server 2008?
a) Geometry
b) HierarchyID
c) XML
d) Date and Time

6. How many nodes can you cluster with Microsoft SQL Server 2008 Enterprise Edition?
a) 2
b) 4
c) 8
d) 16

7. Which of the following has been added to Service Broker in Microsoft SQL Server 2008?
a) Service Priorities
b) Conversation Priorities
c) Contract Priorities
d) Both a and b

8. The largest SQL Server installation is of what size?
a) 10-20 Terabyte
b) 20-50 Terabyte
c) 50-90 Terabyte
d) >100 Terabyte

9. Which tool in Microsoft SQL Server 2008 provides a graphical user interface to monitor an instance of the Database Engine or Analysis Services?
a) SQL Server Execution Plan
b) SQL Server Management Studio
c) SQL Server Profiler
d) None of the above

10. Can you enforce the Windows password policy on your Microsoft SQL Server 2008 accounts?
a) Yes
b) Depends
c) Occasionally
d) No