Mining Plans : Not just for the plan cache Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database. Erin Stellato ◆ August 16, 2018 0
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