I Do Declare written by Joe Celko. "Joe Celko highlights some key areas that SQL developers need to be aware of in order to more effectively write SQL code, and offers heuristics for guidance."
You will have to give Idera your info to register.
https://www.idera.com/resourcecentral/whitepapers/i-do-declare-sql-programmi...
this tip was good. Add a CHECK() constraint for the actual range of the attribute. One of my favorite horror stories was an order entry system that allowed negative quantities. The application treated the negative quantity as a return or refund and sent a check. Order -5000 items at $50 each and wait for the check in the mail! The most common constraints that should be used, but are usually skipped, are to establish cardinals: