Secondary Navigation. 1  Active Duty Dental Care. 2  Guard/Reserve Dental Care. 3  TRICARE Dental Program. 4  TRICARE Retiree Dental Program. 5  Enrolling in the TRICARE Retiree Dental Program. Costs. 6  Dental Benefits for Survivors. 7  Find a Dentist.
â¢ Although char and varchar are character data fields, char is a fixed length data field and varchar is a variable size data field. â¢ Char can store only fixed size non-Unicode string characters, but varchar can store variable sizes of strings.
I guess you cannot index a VARCHAR(MAX)/NVARCHAR(MAX) column. coming back to your question: I dont think it is bad to use VARCHAR(MAX) is bad. If you are storing smaller piecs of data in a VARCHAR(MAX) column, it will be treated as normal. If you dont want to index the column, then you can definitely go with VARCHAR(MAX) option. But most people do not advise that. First of all, by having a VARCHAR(MAX) will confuse some one who looks at the data later on.