I am currently looking at a database that has been setup by the default installation routine of AppFabric. Looking at the creation scripts I encountered this partition function:
CREATE PARTITION FUNCTION [MSAppServerPF_ASWcfEventsTable](datetime2(7)) AS RANGE RIGHT FOR VALUES (N'0001-01-01T00:00:00.000') GO
And it is being applied to a table that way:
CREATE PARTITION SCHEME [MSAppServerPS_ASWcfEventsTable] AS PARTITION [MSAppServerPF_ASWcfEventsTable] TO ([PRIMARY], [PRIMARY]) GO
I wonder what this specific partition style effects in. I was under the impression that you store boundary values into the partition function by which the data will be partitioned.
Unfortunately, looking for this on the web I could not find a similar example using just one
DATETIME2 value in the partition function definition.
Can someone shed some light on this for me?