It's my first go at partitioning in SQL Server, I learned from the Brent Ozar guide which is fantastic :)
A few times I have ran into a weird scenario; when I run:
SELECT * FROM ph.FileGroupDetail ORDER BY partition_number Go
There is the same filegroup showing twice with 2 different partition_numbers, 1 correctly at the end with a range value, the other at the start with a null range_value.
Couple of questions:
How is this happening, where have I gone wrong?
How do I resolve the issue, that means how to get rid of the one at the start as I already have an empty partition at the beginning.
I've tried deleting the file (worked when it was empty) and filegroup, but filegroup said it couldn't be deleted.
Can someone explain please how this has happened and how to get rid of the partition 2 entry?