In all your stored procedures (yes ALL) have comments. At minimum each should have a header block and each block of code that isn’t immediately decipherable by another programmer should have an explanation.

Also, make all your header blocks the same.

Here’s a sample header. /************************************************************
* Description: Describe the purpose of the object. If necessary,
* describe the design of the object at a very high level.
*
* Input Parameters:
*
* Output Parameters:
*
* Error Conditions Raised:
*
* Author:
*
* Revision History
* Date Author Reason for Change
* ————————————————————————————————
* 03 JAN 1997 J.Schmoe Created. ************************************************************/

Interested in automating the creation of your Folder’s procedures? Ask me how we do it at @solnsexec on twitter.