[dba-SQLServer] Yes/No in SQL Server

from bol "Microsoft® SQL Server™ optimizes the storage used for bit columns. 
If there are 8 or fewer bit columns in a table, the columns are stored as 1 
byte. If there are from 9 through 16 bit columns, they are stored as 2 
bytes, and so on."


>From: "John Colby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] Yes/No in SQL Server
>Date: Sun, 1 Jan 2006 12:46:25 -0500
>
>So what happens internally?  Does SQL Server pack/unpack as many y/n
>(boolean) values as will fit in an integer or something like that?
>
>
>John W. Colby
>www.ColbyConsulting.com
>
>Contribute your unused CPU cycles to a good cause:
>http://folding.stanford.edu/
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
>Harkins
>Sent: Sunday, January 01, 2006 11:24 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Yes/No in SQL Server
>
>bit
>
>Susan H.
>
>What data type is used to store Boolean values in SQL Server?
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>