Home Forums SQL Server 2008 T-SQL (SS2K8) Indexing - Should primary key be a natural key or an identity? RE: Indexing - Should primary key be a natural key or an identity?

  • Again, there are certainly times when a shorter clustering key and more covering indexes are warranted. But not by default. In fact, that should never be by default.

    I wish somebody told it to the guys in Microsoft.

    _____________
    Code for TallyGenerator