Best Practice Guidelines for optimal performance while using the new SQL Server 2008 features: Filtered Index/Statistics, Resource Governor, Row Compression , Page Compression, Server Configuration Option: 'optimize for ad hoc workloads', Plan Freezing, Table-Valued Parameters, Disabling Table Lock Escalation, Transparent Data Encryption and more.