title: Does the size used with NVARCHAR matter?
body: <p>Every time I create a table I wonder if there is any performance difference whether I say <code>nvarchar (100)</code> or <code>nvarchar (1000)</code> assuming that actual string size will be less than <code>100</code>. So is there?</p>