Good question!

I learned something new. 🙂

Thanks!

Hi,

try this:

--- Create Partition Range Function

CREATE PARTITION FUNCTION TestDB_PartitionRange (datetime)

AS RANGE LEFT FOR

VALUES ('2010-10-21');

GO

--- Attach Partition Scheme to FileGroups

CREATE PARTITION SCHEME TestDB_PartitionScheme

AS PARTITION TestDB_PartitionRange

TO ([PRIMARY], [Secondary]);

GO

--Create table on partition scheme

CREATE...