Small methods - Small sprocs

Posted by Berlioz on Stack Overflow See other posts from Stack Overflow or by Berlioz
Published on 2011-01-05T14:44:01Z Indexed on 2011/01/05 14:54 UTC
Read the original article Hit count: 298

Filed under:
|

Uncle Bob recommends having small methods. Do stored procedures have an ideal size? Or can they run on for 100's and 100's of lines long?

Also does anyone have anything to say about where to place business logic. If located in stored procedures, the database is being used as data processing tier.

If you read Adam Machanic, his bias is toward the database, does that imply long stored procedures that only the author of the sproc understands, leaving maintainers to deal with the mess?

I guess there is two inter-related questions, somehow.

Thanks in advance for responding to a fuzzy question(s).

© Stack Overflow or respective owner

Related posts about tsql

Related posts about design