More SQL Server 2008 performance tricks

1. Optimize for ad hoc workloads option

http://msdn.microsoft.com/en-us/library/cc645587.aspx

and http://sqlskills.com/BLOGS/KIMBERLY/post/Procedure-cache-and-optimizing-for-adhoc-workloads.aspx

2. New compression features in SQL Server 2008

http://www.sqlskills.com/blogs/kimberly/post/SQL-Server-2005-and-2008-Compression.aspx

Also see this article for deciding on when to apply database compression and whether to use ROW or PAGE level compression...

http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

3. Filtered indexes

http://technet.microsoft.com/en-us/library/cc280372.aspx