Hi,

Refer this link for optimization and database design issue and solution.

[url]www.sql-server-performance.com[/url]

Thanks , Amit



[email]begenerichotmail.com[/email] (Mike Thompson) wrote in message news:<91e39a0b.0306251156.37e5bc48posting.google. com>...
> Quick question - since the values will all be from 1-100, is there any
> performance advantage to using tinyint instead of int?
>
> Thanks.
>
> Mike