Please remember to check Books On Line and forums search before posting your query, here are some additional referrence http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx http://www.sql-server-performance.com/articles/per/index_not_equal_p1.aspx http://www.mssqlcity.com...