Different Approaches to Correct SQL Server Parameter Sniffing
Plan Caching and Query Memory Part 1: When not to use stored procedure or other plan caching mechanisms like sp_executesql or prepared statement | SQLWorkshops.com Blog
Improve stored procedure performance in SQL Server
Online Documentation for SQL Administrator for SQL Server | SQLManager
Understanding Stored Procedures and Functions in Relational Databases