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).