Home Forums SQL Server 2008 SQL Server 2008 - General Partition key should be part of Primary key RE: Partition key should be part of Primary key
getoffmyfoot
Hall of Fame
Points: 3338
More actions
October 4, 2010 at 12:43 pm
#1231198
No it does not need to be part of the primary key. In fact most partitions are not on the primary key but on some date field. Which is what Jeff was trying to say above I think. So keep your primary key as-is.