Total Size Limit

Updated in 2024

Microsoft SQL Server has a row-size limit of 8,060 bytes. Although SQL Server supports row-overflow storage for certain variable-length data types, large rows may still affect performance because data is stored in 8-KB pages.

INFO: For information about SQL Server row-size limits and row-overflow storage, see Microsoft SQL Server Maximum Capacity Specifications: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server.

Therefore, we recommend that you pay attention when adding UDFs, especially String fields, which typically require more storage than other field types. If the combined size of all fields exceeds the supported limit, a warning message advises you to reduce the size of the field being added or reduce the combined size of all UDFs. Ignoring this warning may result in data loss.

NOTE: Memo fields have a special structure and do not count toward the 8-KB limit. These fields occupy only 4 bytes in the record as a reference to data stored externally.