Yeah, I've been using comma-delimited lists myself. My question really is a matter of a clean method for passing a large number of parameters to a stored proc using ADO.Net....

Ditto. Try using a clustered index with the columns listed covering the index and compare the execution plans before making a decision. Make sure that you specify a reasonable value...

Ditto. Further, using an index optimizer hint can be tricky to maintain. If the index is removed sometime in the future, you will need to "track" through your code and...

Thanks for the confirmation. That's what I released into QA and we're testing. I'll post the results later.