title: What data type I should preferably use for storing flag fields in sql server?
body: <p>What data type I should preferably use for storing flag fields in sql server, bit(if I have only 0,1 and null), tinyint, smallint or int for flags which cannot be accommodated into bit?  Does it effect my query performance? </p>