How SQL Server Packs BIT Columns Into a Single Byte

A common worry about bit columns is that a table full of yes/no flags will waste a byte on every flag. It will not. SQL Server packs bit columns together, up to eight of them…