Here is the content from our great session on Stored Procedure Optimization Techniques by Kimberly L. Tripp of SQL Skills.
We have uploaded the slide deck & demo files: https://sqlglasgow.sharepoint.com
The session recording is also in the above folder (although we seemed to have had a cropping issue with the video.)
Enjoy!