O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing Data Integrity

The ability to ensure you can retrieve persisted data without error is of primary importance. Without data confidence, no query answer can be guaranteed to be correct, and there is not much point in worrying about data availability or performance.

Thus far in the chapter you have seen methods to review and query your data for quality using implicit means. In this section, you will take a proactive approach to data integrity through explicit definitions.

Your first concern is to make certain that you have exactly one master copy of the data that is used throughout the enterprise. Then, to be proactive, you must explicitly define the data using entity and attribute values.

It goes without saying, but we will say it anyway: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required