SQL Server performance bits - avoid compilations, help optimizer with better plans

When you are dealing with SQL Server performance issues, not every issue can be classified as a problem for SQL Server. There are common characteristics within the issues, such as: Ad-hoc query execution typical taking longer time. Intermittent High CPU. Blocking irrespective of slow performance. Few times a memory pressure related errors on error log. So how can you help the SQL Server to fine tune the query performance using the internal optimizer techniques, which is called caching mechanisms....(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2010/08/25/9456.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9456" width="1" height="1">