You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will store multilingual data.
The database will contain a table that has 100 million rows.
The table will contain 1,000 columns that are based on the nvarchar(max) data type. For each column, only2 percent of th e rows will be populated.
You need to design the table to optimize storage space.
What should you do?
A.
Use row compression.
B.
Use NTFS file system compression to reduce the disk space used.
C.
Define the columns as sparse columns.
D.
Change the column data types to varchar(max).