May 11, 2005 at 10:11 am
I was going through series of DBCC commands which are called database consisitency commands but the question popped up in my mind is how to know that whether your data is inconsistent?
If anybody knows please help
May 11, 2005 at 10:30 am
You should have RI implemented to solve most of this and then you will have checks based on business rules to determine if things are cnsistent.
May 12, 2005 at 10:46 am
Remember that system DBCC commands are checking the system for structural consistancy. It could care less about the meaning of the data, it just wants the physical structure that holds the data to be intact.
Like Steve said, your database design should implement RI and enforce it through FKs and triggers and such to ensure that your DATA is logically consistant.
We're really talking about data consistancy versus dataBASE consistency, the data versus the means of storing it.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 12, 2005 at 4:18 pm
As a side note, data consistency generally follows business gogic. in some cases it has to be inconsistent (say, order history of deleted customers)
Yul Wasserman
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply