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????