Optimize For Adhoc Workloads
![Midnight DBA show](https://d3dthqtvwic6y7.cloudfront.net/podcast-covers/000/046/610/small/midnight-dba.jpg)
Summary: 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.
Summary: 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.