Hi,
What are the disadvantages of using many columns with varchar (4000) or nvarchar (4000) in terms of performance, DB size, index size (CI, NCI, CCI) and IO? Some developers argue that anyway only the actual size of the content is used, and thus it does not make any difference to use basically v / nvarchar (4000) for most string-columns.
Thank you
Regards
Nicole