Optimize for Ad-Hoc Workloads
SQL Server is using part of its memory for storing execution plans of the queries that can be used repeatedly without recompilation. Every compilation of execution plan has its cost...
Tag: ad-hoc