https://www.dotnetzone.gr:443/cs/blogs/dotnetrules/archive/2012/08/10/optimising-sql-server-for-ad-hoc-workloads.aspxIn this post I will be demonstrating with hands-on examples how to optimise your SQL Server for “ad hoc workloads“. I will be using the view LookIntoPlanCache that I created in this post .Make sure to read this post if you are not familiar with termselCommunityServer 2.1 SP3 (Build: 20423.1)