9. You have a database table with a varchar(600) field in it. Most of the records in
the table have a null value for this field. How can you save space?
A. Move the data into a second table
B. Use sparse columns
C. Install a third-party tool on the machine to compress the data
D. Use the SQL Server 2008 Declarative Management Framework
The correct answer is A. Sparse columns will take up less space for varchar
columns. Sparse columns will take up less space for most columns, but
cannot be used for text, ntext, image, timestamp, user-defined data type,
geometry, or geography or varbinary (max) with the FileStream attribute
can be sparse. Answer C is incorrect; this is not the best approach. Answer D
is incorrect, as the Declarative Management Framework will not save
you space.
Bạn đang xem 9. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC