OPTIMIZE FOR AD HOC WORKLOADS SQL Server by Amit Bansal

3 views

This is a good option to optimize plan cache and avoid plan cache bloat. Better for OLTP environments with many single-use ad hoc queries.

 
Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *