Junior DBA talking to Senior DBA about Bitmap Filters and Bitmap Indexes:

Resources:

Intro to Query Execution Bitmap Filters

http://en.wikipedia.org/wiki/Bitmap_index

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1933280&SiteID=1