How SQL Server Stores DECIMAL and NUMERIC, Down to the Bytes

· by · in

decimal and numeric store a sign byte plus a little-endian integer scaled by the column scale. Why precision buys storage in tiers, and why an oversized decimal is not free.