Optimize For Adhoc Workloads

Published: July 22, 2011, 6 a.m.

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.