Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.