HIT Consultant Insightful coverage of healthcare innovation
> Idera > 5 Most Common Critical SQL Integrity Issues

5 Most Common Critical SQL Integrity Issues

White Paper Published By: Idera
Published:  Jan 08, 2014
Type:  White Paper
Length:  11 pages

The word “integrity” has multiple meanings in the SQL Server world. One meaning deals with the quality of data stored within SQL Server.

This form of integrity is maintained through proper data typing, constraints (default, check, unique, and key), and data validation processes. The other definition of integrity deals with the logical and physical consistency of the underlying structures of a database. Logical and physical consistency is the much more complex of the two, and this is the subject we are going to tackle in this whitepaper.

Tags : 
idera, sql, integrity sql, data typing, data validation, physical consistency, data storage