Great explanation from Craig. We have a few articles on the site as well:

http://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/

http://www.sqlservercentral.com/articles/1251/