O'Reilly logo

Microsoft® SQL Server 2005 Unleashed by John Kane, Tudor Trufinescu, Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

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

Chapter 21. Implementing Data Integrity

IN THIS CHAPTER

The value of your data is determined by its integrity. You may have heard the phrase “garbage in, garbage out.” In the database world, “garbage in” refers to data that has been loaded into a database without validation or without data integrity. This “garbage” data can then be retrieved (“garbage out”), and erroneous decisions can result because of it.

Implementing good data integrity measures is your best defense against the “garbage in, garbage out” scenario. This involves identifying valid values for tables and columns and deciding how to enforce the integrity of those values. This chapter ...

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