System Stored Procedures remain part of my troubleshooting toolbox. I use these familiar entry points before moving to more detailed views.
List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070
In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.
Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?
After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.
Finding Dead Code: Stored Procedures Nobody Calls
Investigate dead code with cached procedure statistics, dependency checks and retained snapshots, then quarantine candidates before removal.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.
A Custom db_executor Role for Stored Procedure Access
The app gets a permission error while it works for you as a sysadmin. Here is how a db_executor role fixes it without opening everything.
SQL SERVER – Different Methods to Know Parameters of Stored Procedure
Need to know parameters of stored procedure code quickly? Here are two methods, including sp_help, that list each parameter with its type and order.