"...like I'd just found him in my living room floor in his undies with my dog and a jar of peanut butter."

Just what response is the author expecting here. ...

Thanks, Michael (and some others) for your insightful posts.

I'm glad they chose to reclassify Pluto if for no other reason than this very discussion. Our universe and our planet...

In addition to latitude, how far west one resides within his time zone influences time sunset.  Seattle gets sort of wobbled west this time of year.  It always amazed me...

I don't drink soda so early in the morning.  The rest is on par.  No, I DO successfully work from home once a week.  It took me a few times...

I have been laughing out loud reading these.  Thanks for the topic, Steve.

David.Poole's post cracked me up.  My mother was rather the opposite, as she RETYPED at least 30 feet...

If "No" is, indeed, the correct answer (and I don't think it is) why the downgrade?  I have a few SQL Server 2000 applications whose security models need revisiting before...

Still perfect, Chris.  A no brainer.

Now developers and DBAs simply need to carefully recognize the definition of data integrity.  Which is still out of range of this thread, you're right.

This...

I guess we moved beyond foreign key constraints because limiting the discussion to DRI or even RI through triggers isn't much of a debate.  If you participate in these forums,...

I'm not communicating effectively and I apologize.  Again, I think many are not making a distinction between enforcing data integrity and enforcing business rules related to process.

No sh** you better...

The point I tried to make earlier, is that although you CAN enforce business rules with constaints and triggers, you SHOULDN'T.  Those belong in an application's business logic layer, and...

Neither of you mention company policies.  Is the data integrity compromised if, say, a price for an expensive product is zero?

Define INTEGRITY

Paul illustrates how carefully you have to consider enforcing data integrity versus business rules. 

I think an account balance is a good example of a data element that can go...

Max makes a good point.  Many n-tier developers try to drive too much into the middle "business layer".  But I would argue enforcement of a data model is not business...

Thank you, Frank.  I've worked on too many systems with both poor DBAs and Developers.  I think the same developers who dismiss DRI likely also design code with everything public,...