Ok, I just started studying for the 70-432 exam (SQL2k8 implementation/maintenance.) I bought a book for it and one of the questions in the first chapter reads as follows:
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.
Now, I would've expected the answer to be (B) but the book is telling me (A) is the answer.
Can anyone tell me why this is the case?