Choosing a clustered index
Managing several auto-increments on a single table, when one column has to be numbered within the scope of another.