Another argument for stored procedures
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.
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.