How to use it
- Enter the number of columns in each supported data group.
- Provide an average byte length for each text column.
- Optionally add nullable overhead and calculate.
Table Row Size Calculator
Estimate row width and projected storage for larger row counts.
About the Table Row Size Calculator
Estimate a logical table-row width from common column groups before projecting that size across one thousand or one million rows.
Estimation logic
The estimate uses 4 bytes per integer, 9 per decimal, 8 per date/time value, and the entered average length per text column.
Example
Three integers, two decimals, two date/time values and two 50-byte text values produce roughly 146 bytes plus nullable overhead.
Engine differences
This is an estimate, not a storage-engine calculation. Actual layouts vary with data types, encodings, null maps, page headers, compression and row metadata.