>>>>In a table having about 26 million records and counting, it contains only a few fields however, what would be the impact of using Char(100) field VS Text or NVarChar field, whatever the field type which would be used? The reason I ask is that the first 26 million records won't have a value in this new field. It is just a caption to enter some text about upcoming images. The table takes 30 GB presently totalling the data + index + reserved. Whichever field type I choose, would there be a space advantage of one over the other or this doesn't matter in SQL Server?
>>>
>>>with 26 Miliion record with null value the better solution is
>>>VARCHAR(100) with Sparse attribute
>>
>>Right except you will not be able to index that column.
>
>Is indexing 26 million blank records a good idea ?

http://msdn.microsoft.com/en-us/library/cc280604.aspx