Optimize for Ad Hoc Workloads - SQL Server Configuration Parameter
Refer to http://www.sqlvideo.com/AllVideos/Opt... for additional details.
This SQL Server Video includes demos. You have the possibility to practice the hands-on examples while watching the video.
SQLTest Tool (http://www.sqltest.org) simulates the hands-on labs for you, no registration necessary.