Possible Duplicate:
Are there disadvantages to using VARCHAR(MAX) in a table?
If I know that the column real size is only up to 100 chars but I still want to use nvarchar(max). What should be the performance cost and why?
Asked
Active
Viewed 44 times
0
-
It doesn't matter on how many records you currently have. In the long run you will have that amount of records. By the way 8k is very very small. – John Woo Feb 03 '13 at 15:36
-
why this is dupliate? no one explaind why we have performance issues.. – dimka87il Feb 03 '13 at 16:10
-
@dima did you *read* the answers in the linked question? Did you follow all of the links and read those too? – Aaron Bertrand Feb 03 '13 at 16:43
-
Also you say "I still want to use nvarchar(max)" - if you only need up to 100 characters, can you explain WHY you want to use nvarchar(max)? – Aaron Bertrand Feb 03 '13 at 16:53
-
i just want to know what are the overheads ... the "WHY" is not important i just want to understand why this creates performance problems :( – dimka87il Feb 04 '13 at 09:38