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 tableB. Use sparse columnsC. Install a third-party tool on the machine to compress the dataD. Use the SQL Server 2008 Declarative Management Framework