I have a table which will be exceptionally large over time. I have a column within this table which keeps track of whether something happend or not. It can only be yes or no. on or off. Would the datatype of 'bit' be my best bet here? My goals are a small footprint and extremely fast data access.
I am thinking 0 = no and 1= yes in this case so bit will work. Can you give me any suggestions?