Abhijeet Chavan (12/14/2010)
beginners SQL book will really help to understand the concept of Indexes.
Or maybe the introductory series I wrote on indexes?
http://www.sqlservercentral.com/articles/Indexing/68439/
When we say clustered index can also have non unique rows, so how sql manages to search a row.
Covered here: http://www.sqlservercentral.com/articles/Indexing/68563/
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