title: Tinyint vs Bit?
body: <p>I don't want to touch-off a religious war here, but there seem to be two schools of thoughts in how to represent boolean values in a database. Some say <code>bit</code> is the appropriate data type, while others argue <code>tinyint</code> is better.</p>
  
  <p>The only differences I'm aware of are these:</p>
  
  <ul>
  <li><code>bit</code>: storage size is 1 bit, possible values are 0 or 1</li>
  <li><code>tinyint</code>: storage size is 1 byte, possible values are 0-255</li>
  </ul>
  
  <p>Which data type is better when you need to represent boolean values? Is <code>tinyint</code> worth the extra overhead "just in case" you need to values > 1?</p>