Krishna (3/27/2009)
1.) There should be at least one clustered index for a table which should be Narrow, ever-increasing, unique
At least one?
5.)Think about Covering indexes to cover all the columns retrieved in your query
Not all queries can be covered, not all queries should be covered. Sometimes the cons outweigh the pros. (Think of the size of a very large covering index)
6.) Order of Index columns pretty important as SQL server maintains indexes only on the lading edge of the indexed columns
I assume you mean statistics on the leading column?
There's a lot, lot more to order of columns that that. I wrote two blog posts on just that topic
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