A very nice interesting and easy to read article on partitioning.

There are a couple of errors in the syntax though with regards to creating a partition function:

CREATE PARTITION FUNCTION partfunc (int) AS

RANGE LEFT FOR VALUES (1000, 2000, 3000, 4000, 5000);

CREATE PARTITION SCHEME MyPartitionScheme AS

PARTITION Mypartfunc TO([FG1], [FG2])

GO

The partition function is named 'partfunc' though the partition scheme references partition function 'Mypartfunc'. Additionally, there are less filegroups set in the partition scheme than there are partitions in the partition function. I guess these are just typos.

I would also have split the article into several articles over a series as most people prefer short articles to absorb and try out the features themselves. Splitting, Merging, Switching and the rolling window scenario are detailed topics in their own right to which only a brief mention has been made in this article. Maybe a detailed follow up ?

Overall though I thought an interesting and worthwhile introductory piece to partitioning. Thanks.