Develop a standard header for stored procedures, views and user-defined functions. Include details such as a brief description of the object, specification document, author, date created, change history, etc.

Throughout the application, develop and maintain a uniform style of commenting. This improves the readability of the code and represents a professional approach.

It's a shame that neither of these two interesting points get more than a mention.