SQL Server Performance

Partitioning and Identity Column

Discussion in 'SQL Server 2005 Database Mirroring' started by ctichenor, Jun 4, 2007.

  1. ctichenor New Member

    Folks,

    I'm new to SQL Server 2005 partitions. I need a fundamental question answered before I put more time into my research. Are there any limitations that partitioning puts on the use of identity columns. If, for example, the identity column is not part of the partition key is there any issue with the identity column being correctly incremented and stored across the various partitions?

    Thanks in advance for your help
  2. MohammedU New Member

Share This Page