(Arthur Fuller) SQL Server allows only one clustered index per table because a clustered index reorders the table, arranging the data according to the index key. This results in wonderful performance–when you only have to worry about one particular column.
Read More - Register for Free Membership