Thanks for all of the feedback. I think the with recompile option is probably the best choice looking back. The hints thing didn't work because you really didn't know...

Good article on some of the things DBA's should look out for when management approaches them. I think the main point here is that often, DBA's don't fully understand...

It was a good read. There was plenty of information and I understand your want to explain why you took the route you did. Having said that, it...

Adam,

I think we are going to have to agree to disagree.  Your example  in no way represents business logic.  That is simply a data rule.  Again, I urge you...

Hi Peter,

Is what I stated above what you were looking for with regard to a trade

My example doesn't require more than one stored proc because there is no business logic in it.  The model that each of those trades occurs from or because of is...

Adam I agree with everything you just said, except your definition of business logic. Business logic is the logic that is applied to the data in order to obtian...

A person I work with and who I repect a great deal pointed out that in some of my replies I have sounded like a pompus ass. If you...

This is not a microsoft V. Oracle issue. It is a fundamental design issue. Oracle doesn't handle business logic any better than Microsoft or

Sybase or IBM. ...

Much like the post before, you are confusing business logic with integrity. I agree on the notion of garbage in garbage out, however who are you to decide what...

I am sorry if you believe that the article implies that. It wasn't intended to. I am not asking you to buy into anything and I too have...