Version-Specific SQL Server Recommendations

If you have SQL Server 2008. You should enable the option ‘Optimize For Ad Hoc Workloads’ If you have SQL Server 2005. You should enable the option ‘Forced Parameterization’