Optober – SQL sp_configure options – Optimise for Adhoc Workloads

Optober continues with more sp_configure option descriptions. This time it’s all about Optimise for Adhoc Workloads. This is an option that I never had much to do with until I discussed it with a colleague who uses it as a default install option. That got me to thinking….