You are designing a document repository application that will contain over 100,000 documents. The repository will have the following specifications:
* Documents can be associated to 30 different properties
* Most documents will have less than 10 properties defined
You need to design a single table for the application. The solution must use the minimum the amount of storage space. What should you include in the design?
A.
an XML data type
B.
nvarchar() null
C.
sparse columns
D.
varchar(max) not null