Optimize For Adhoc Workloads

There’s a lovely sp_configure option that can help you keep the size of your plan cache under control. Let’s go have some fun.