Michel,
To my understanding of the way SQL server works, that is the optimal way to do
most tables. There are a few cases where tables using other schemes are better but they are very specialized circumstances.
>All the indexes on all tables are non-clustered but the primary key of each table which is clustered. Is there anything to adjust in there?