Clustered and non-clustered indexes in SQL Server

Clustered and non-clustered indexes in SQL Server
When do I use a clustered index vs. a non-clustered index? This is somewhat of a tough question to answer, and frankly, the one I'm going to give is the age old standard database administrator's answer; "It depends." There are numerous factors into the when and where of index placement. The good news is that there are only two options per-sé. The bad news is that there are fairly esoteric gains and limitations to both.



See Also:
Take a look at these handy SQL Server indexes
Partition your indexes for improved performance in SQL Server 2005