If your longest value in a very column is twenty five people, then define your column as VARCHAR(twenty five). Avoid defining all character columns to a substantial default size. On top of that, define columns as VARCHAR when that is definitely everything is needed as an alternative to using NVARCHA