Grant Fritchey (4/22/2009)
That's a huge topic. There have been books written about it (note the bottom of this post 😀 ).
Not enough books, unfortunately. I'd love to have a definitive book on indexing (and just indexing) that I could refer people to.
Manz, you may also benefit from two blog posts that I wrote.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability