SQL Server Performance Forum – Threads Archive

Partitioning and Identity Column

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

I don’t think there will any issue with identity columns for partitioned tables… http://msdn2.microsoft.com/en-us/library/ms345146.aspx
http://www.sqljunkies.com/article/f4920050-6c63-4109-93ff-c2b7eb0a5835.scuk
http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>