The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter Sniffing

It is one of the most mysterious behavioural quirks in T-SQL development. You are troubleshooting a slow database application endpoint and discover a specific stored procedure is taking minutes to run