O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

Data Types

Choosing the right data type is an important step in creating efficient tables. If you choose the wrong data type for a column, your data integrity and system performance may suffer. The beginning of data integrity is the use of proper data types. Exceptional system performance depends on the right data types.

Consider a table used to track customer records for United States–based customers. Imagine that the DBA set the data type for the zip code column to char(50). Two major problems will exist because of this action. First, every record will consume 50 bytes for the zip code column alone (each record would consume 100 bytes if the nchar(50) data type were used). If the table has 200,000 records in it, the DBA has wasted a lot of ...

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