Tools › Row size calculator

SQL Server table size estimator (row bytes)

A row is not the sum of the brochure sizes. Null bitmap, variable offsets, and the 8,060-byte limit all count. Type the columns.

Columns (type per line, optional name). Examples: int, nvarchar(80), decimal(12,2), datetime2, varchar(255)

Rows to size Avg fill of variable cols (0–1)

This is a planning estimate, not a DBCC result. Compression, fill factor, and off-row LOB pages change the real file. Related: int vs decimal, varchar vs nvarchar.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.

Clock in free