http://www.sqlservercentral.com/Content tagged T-SQL, Performance Tuning and Scaling, SQL Server 7, 2000, Indexing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexeshttp://www.sqlservercentral.com/articles/Performance+Tuning/938/2003/03/14http://www.sqlservercentral.com/articles/Performance+Tuning/938/