How SQL Server Stores MONEY and SMALLMONEY, and the Rounding Trap

· by · in

money and smallmoney are just integers scaled by 10000. The real page bytes, why the ranges are what they are, and the four-decimal truncation trap that bites calculations.