Tip : Extend DDL Triggers for more functionality: Part 2
May 2013
I talk about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.
Tip : Extending SQL Server DDL Triggers for more functionality: Part 1