on 12-05-2016 1:11 PM
dear all
i recently performed a test between two tables.
table1 had 1 field with a data type NVARCHAR(10), table 2 had 1 field with a data type NVARCHAR(1000).
i populated both tables with the same data and found they both consumed, exactly the same amount of memory.
so, here's the question.
assuming i do not need to use the width for limiting data or anything, why would i specify each field in a table with the width i would expect the field to contain. why don't i just have each field specified as NVARCHAR(1000), or something like that.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.