cluster index in sqlserver

A clustered index determines the physical order of data in a table. 

A clustered index is analogous to a telephone directory, which arranges data by last name.

Because the clustered index dictates the physical storage order of the data in the table, 

a table can contain only one clustered index.

For SQL Server 2005: 1 Clustered Index + 249 Nonclustered Index = 250 Index

For SQL Server 2008: 1 Clustered Index + 999 Nonclustered Index = 1000 Index