I'm implementing a custom log table for Serilog SQL Server database logging. I notice that almost all text columns are default to nvarchar(max). I know varchar should be sufficient for us but are not sure if there is a need for messages to exceed 8000 characters. I'm kind of new to this. Is varchar(max) necessary for general application logging?
Please tell your opinions based on your experience.
Thanks in advance.