||SQL Server Tips by Gama and Naughter
Nvarchar stores variable length Unicode data. This example is very
DECLARE @b nvarchar(10)
select DATALENGTH(@b), LEN(@b)
Bigint can store numbers between -2^63 and 2^63-1, that is
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Int can store numbers between -2^31 and 2^31 - 1, that is
-2,147,483,648 to 2,147,483,647.
Smallint can store numbers between -2^15 and 2^15 - 1, that is
-32,768 to 32,767
Tinyint can store numbers between 0 and 255.
Bit can be either 1 or 0. Any numeric value can be attributed to a
bit variable turning it into 0 if the original value was 0,
The above book excerpt is from:
Turbocharge Database Performance with C++ External Procedures
Joseph Gama, P. J. Naughter