So defining it as a sparse column and creating a filtered index will enable SQL Server to optimize access to this column and also save space. Now this actually is a violation of the normalization ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results