YOU HAVE A DATABASE TABLE WITH A VARCHAR(600) FIELD IN IT. MOST OF...

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.