SQL Server 2005 has following features

• A. Dynamic Management Views
• B. FILESTREAM
• C. Powerpivot
• D. In-memory capability