I'm not sure I understand the question. Are you trying to tune queries where there is a lot NULL columns?
If so, yes, this can be an issue in 2005 and prior version because NULL values and indexes don't mix will to arrive a selective indexes. SQL Server 2008 has a filtered index that could help you here.
If that's not the kind of information you're looking for, please clarify your concerns. Thanks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning