What are some of the differences between clustered and nonclustered indexes?
A1:
The number of indexes available (1 for clustered, 249 for nonclustered) and the contents of the leaf level of the index (data for the clustered index, rows pointing to the data for the nonclustered index).