patternsqlModerate
Does a SQL Server bit column really use a whole byte worth of space?
Viewed 0 times
bitreallyspaceworthcolumnsqlwholebytedoesserver
Problem
I was poking around SSMS and noticed the "size" of my
Did I misunderstand what I was looking at?
INT columns were 4 bytes (expected) but I was a bit shocked to see my BIT columns were a whole byte. Did I misunderstand what I was looking at?
Solution
How many bit columns do you have defined in the table? I found this on MSDN, it says 8 or less bit columns are stored as one byte.
http://msdn.microsoft.com/en-us/library/ms177603.aspx
http://msdn.microsoft.com/en-us/library/ms177603.aspx
Context
StackExchange Database Administrators Q#13668, answer score: 17
Revisions (0)
No revisions yet.