This document is my attempt at handling the large intersection problem in C# using BitArray and Byte[] arrays.  It contains a section on how to compile the code for use from within SQL Server via T-SQL's EXEC statement.  Click on the following link to view the document: Self-Inflicted Project #2: Large Intersection Problem.