Category Archives: Tips & Tricks

Tips: Avoid single-use cached plan with ‘optimize for ad hoc workloads’ in the SQL Server 2008 or later

In SQL Server 2008, there is a new server configuration option introduced, called ‘optimize for ad hoc workloads’. This option can improve the efficiency of the plan cache for single use ad-hoc queries (or called dynamic SQL). When this option … Continue reading

Posted in Database Engine, Script Library, Tips & Tricks | Tagged , , | 1 Comment