Here are ten precious SQL Server 2005 features that could help you make your DB flying:

  1. TableDiff.exe
  2. Triggers for Logon Events (New in Service Pack 2)
  3. Boosting performance with persisted-computed-columns (pcc).
  4. DEFAULT_SCHEMA setting in sys.database_principles
  5. Forced Parameterization
  6. Vardecimal Storage Format
  7. Indexing made easier with SQL Server 2005
  8. Figuring out the most popular queries in seconds
  9. Scalable Shared Databases
  10. Soft-NUMA

Read full article on MS TechNet