I’m using SQL Server 2008, may be will go to 2012 in near future and I have a question.
I have a table with 10 filleds, that will go to some millions records. In that table I should add a nvarchar(50) which will be used only for some customers, for others this Keyword nvarchar(50) filed will be empty.
So my question is – for the customers that will NOT use at all this Keyword field, this will increase the size of DB or not? What exactly type I should use and at all, what should I do to minimize the recourses used for the customer with Keywords = null ??? I prefer not to make different logic …