#9: Stored Procedure Usage
Keep it simple - make each procedure do one thing only
Use stored procedures to create reusable “components” of business logic
Putting multiple types of business logic into a single stored procedure makes it more difficult to tune, modify, and understand
Document the purpose of each procedure as well as any required input, outputs, and each change made to the stored procedure