Another argument for stored procedures Aaron Bertrand (@AaronBertrand) talks 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. Aaron Bertrand ◆ May 17, 2013 15