2016 Oct 23 - sp_BlitzCache, sp_BlitzIndex new checks
Just when you thought we were done for October, we're turning into ROCKTOBER.
sp_BlitzCache Improvements, All @BlitzErik's Handiwork
- #543 - look up execution plans for a stored procedure by name, the new @StoredProcedureName parameter
- #540 - add warnings for recently compiled plans (last 4 hours)
- #497 - add warning for CLR functions
- #482 - add check for compute scalar operators that call functions
- #422 - add check for table variable use
- #556 - add and improve cursor checks
- #532 - fix double warnings on expensive remote queries
- #559 - fix varbinary conversion error
sp_BlitzIndex Improvements, All By The Incredible Non-Edible @BlitzErik
- #529 - add divide-by-zero handling to stats queries
- #530 - add more clear wording to stats warnings
- #479 - add a check for filtered stats
- #531 - don't get filtered stats on SQL 2005
- #528 - add schema information to collection and results
- #527 - faster stats collection with >50k objects
- #490 - sp_BlitzIndex should be marked to recompile