blog.philipsymons.com
Database Object Types – Some Design Considerations
This posting discusses the use of stored procedures, triggers and views (including materialized) views, along with some of the design issues they present