How should Stored Procedures be used in production for SQL Server?

Use stored procedures when they provide clear operational or performance value, keep contracts explicit, version carefully, parameterize inputs, and monitor plans.