Bit Flag or seperate columns

Question

Bit Flag or seperate columns

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Completely depends on what I'm doing. For instance, I stated it as A.B.C.D, but I'd write it as a 32 bit stream... very handy when doing masks that don't follow the old class system. In that case the tinyints actually impede what I'm trying to do.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

kevin77 SSCarpal Tunnel Points: 4118 More actions · Answer 2

One basic database design principle is to make things as "granular" as possible. Following this design pattern would mean that you would go with the separate bit columns for each answer.