Optimising SQL Server for ad hoc workloads
In 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 terms like Query Optimiser,execution plans and Plan Cache. (
read more)