>
>I wasn't sure if SQL Server handles that such as Varchar, thus only using that space if it is filled.

SQL Server has a varchar. There is a small amount of overhead associated with it, but it works very well.

My two cents is that if the relationship is 1x1, I'd just add the column to the table.