Which is the smallest datatype to store an integer value in SQL Server 2008?

Question

I am creating a small database application. I want to store the count of an item in a database table which will never cross value more than one hundred.

What is the most suitable datatype for this field? I am using this field for some calculation also.

Ray · Accepted Answer · 2011-02-05 15:51:17Z

4

use tinyint - one byte of storage space

answered Feb 5, 2011 at 15:51

Ray

21.9k6 gold badges51 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ryan Elkins · Accepted Answer · 2011-02-05 16:00:47Z

3

While you can use TinyInt, are you sure it will never be more than a hundred? I'd be careful about trying to optimize TOO much. Maybe it's something like a rating where ratings are always between 0 and 100, but if it's something that could potentially go over that at some point in the future, I might just go with a traditional Int. Maybe you need all the memory you can get so you need to really watch what values you use but this isn't too common.

I guess what I'm trying to say is don't get too aggressive about optimization of something that will generally not make much difference at all.

answered Feb 5, 2011 at 16:00

Ryan Elkins

5,79713 gold badges46 silver badges70 bronze badges

Comments

pavanred · Accepted Answer · 2011-02-05 15:52:49Z

1

Tinyint. Allows you to store values from 0 to 255.

answered Feb 5, 2011 at 15:52

pavanred

14k16 gold badges56 silver badges60 bronze badges

Collectives™ on Stack Overflow

Which is the smallest datatype to store an integer value in SQL Server 2008?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related