any thoughts on performance of sparse bit columns vs. just regular (non sparse) bit columns?

generally a client will start searching with a broad search and then start adding attributes, for instance:

bedrooms = 3, area = 'boston'

bedrooms = 3, area =...

Thank you for your answer,

I am most interested in performance, storage is cheap 🙂 Given that constraint, should I just go with regular bit columns?

Any thoughts on...

I"m not a BI guy but just did a little research. Are you speaking about creating a star-schema datawarehouse? Would there be a dimensions table for each...

Would this work in a scenario where you are searching on up to 40 or 50 criteria? I'm trying to design a super fast search of MLS (real estate,...