asked
Get unique partition number to the table partitions on the same column in a database
I created partitions on two tables on the same partition id column. But the sql server is assigning the same partition number to the partitions where I have same partition id column. I want partition numbers to be unique. Is there any way to achieve this????
The partition number is a 1-based counter of partitions within the owning index (or table heap if there is no clustered index). You cannot change it.
15 People are following this question.
