Data Modeling

Data modeling in SQL Server: choosing the clustered index key, and numbering a column per value of another column in the same table.
Choosing a clustered index

Which key to give the clustered index of a SQL Server table: small, unique and increasing, why to avoid a GUID, and the case for the primary key.

Managing several auto-increments

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