Data Types

1.

1 point

Smalldatetime

2 bytes

6 bytes

4 bytes

8 bytes

2.

1 point

DateTime

0001-01-01 through 9999-12-31 January 1,1 AD through December 31, 9999 AD

January 1, 1753, through December 31, 9999

1900-01-01 through 2079-06-06 January 1, 1900, through June 6, 2079 00:00:00 through 23:59:59

3.

1 point

Datetime

6 bytes

8 bytes

5 bytes

4 bytes

4.

1 point

Bit

2 bytes

2GBs

4 bytes

1 byte

5.

1 point

Float

3 or 9 bytes depends on size

8 or 16 bytes depends on size

2 or 6 bytes depends on size

4 or 8 bytes depends on size

6.

1 point

SQL Variant

1-8000 bytes

1Gb

2Gbs

1-4000 bytes

7.

1 point

Binary and Varbinary

1-8000 bytes

2Gbs

1-4000 bytes

1Gb

8.

1 point

Datetime2

January 1, 1900, through December 31, 9999

0001-01-01 through 9999-12-31 January 1,1 AD through December 31, 9999 AD

January 1, 1753, through December 31, 9999

9.

1 point

Date

4 bytes

6 bytes

3 bytes

9 bytes

10.

1 point

SmallInt

-2,147,483,648 to 2,147,483,648

0-255

-32,768 to 32,767

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

11.

1 point

Datetime2

8 bytes

2 bytes

4 bytes

6 bytes

12.

1 point

XML

1Gb

2Gbs

4000 bytes

8000 bytes

13.

1 point

Decimal...Precision and size

1-9....5 bytes 10-19....9 bytes 20-28....13 bytes 29-38....17 bytes

1-9...9 bytes 10-19....13 bytes 20-28....15 bytes 29-38....21 bytes

1-9....1 bytes 10-19....5 bytes 20-28....9 bytes 29-38....23 bytes

1-9....4 bytes 10-19....8 bytes 20-28....16 bytes 29-38....24 bytes

14.

1 point

TinyInt

0-10

1-10

0-255

-255-255

15.

1 point

Smallint

2 bytes

6 bytes

1 byte

4 bytes

16.

1 point

Smallmoney

2 bytes

1 byte

3 bytes

4 bytes

17.

1 point

Int

0-255

-32,768 to 32,767

-2,147,483,648 to 2,147,483,648

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

18.

1 point

SmallDateTime

0001-01-01 through 9999-12-31 January 1, 1 A.D. through December 31, 9999 A.D.

1753 through 9999

1900-01-01 through 2079-06-06 00:00:00 through 23:59:59 January 1, 1900, through June 6, 2079 00:00:00 through 23:59:59

19.

1 point

Datetimeoffset

4 bytes

5 bytes

10 bytes

12 bytes

20.

1 point

Money

6 bytes

8 bytes

2 bytes

4 bytes

21.

1 point

Int

1 byte

4 bytes

8 bytes

16 bytes

22.

1 point

TinyInt

2 bytes

1 byte

4 bytes

2 bytes

23.

1 point

BigInt

-32,768 to 32,767

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

0-255

-2,147,483,648 to 2,147,483,648

24.

1 point

Time

milliseconds

nanoseconds

microseconds

25.

1 point

BigInt Size

2 bytes

6 bytes

8 bytes

4 bytes

26.

1 point

Time

3 bytes

1 byte

5 bytes

7 bytes