[dba-SQLServer]Field Sizes

John Colby jcolby at colbyconsulting.com
Mon Oct 6 08:59:06 CDT 2003

Access stores text and memo data using the exact amount needed (plus
pointers) , i.e. even though the text field says 255 characters if the
string is 10 characters, 10 characters are used for storage.

Does SQL Server work this way of is space "reserved" for the stated size of
the field?

John W. Colby

More information about the dba-SQLServer mailing list