I have table that holds from very basic info. Just a title and a few date fields. There's one field called comments which is varchar(4000) Most of the time we leave it blank, but some times will enter a large amount of data here. Is this a really bad design? Or is this just slightly inefficient?
I would assume the creating a separate table for this column would be better.
note: this is sql server 2008