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

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 s开发者_开发知识库ome calculation also.

---

use tinyint - one byte of storage space

---

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.

---

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