I want to know more about implications of adding a ntext column to an already existing table with 10000+ rows. My estimate is that only 1 out of 100 rows will haveanything stored in the ntext field. Does this mean that space required is counted for every row this table contains? Not only for those rows that have data in this field?
Shall I instead constuct a sub table storing the ntext column with a relation id pointer to the specific row in the mother tale to save space?
View Complete Post