var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: varchar/nvarchar length
I have a pretty straightforward question to do with variable length fields I hope someone can help me with:
When using varchar (or nvarchar), is there any point in specifying a smaller length than the maximum? Does it save space or improve performance at all?
edit: I suppose the max rowsize is an issue. any others?
Last edited by robwhitby; 03-09-07 at 10:07.
Max rowsize is an issue, as is the concept of enforcing constraints and business rules.
here's a related blog post on why not to just use varchar(max) for everything. It's the comments you need to read. The actual post has the wrong idea.