• The article states the following:

    First off, you need SQL Server Enterprise Edition or Developer Edition. None of the other editions of SQL Server 2005 or 2008 support partitioning. SQL Server 2000 and earlier do not support partitioning at all.

    This is not entirely correct, the devil is in the details!

    Partitioning is supported, I believe all the way back to SQL Server 2000, but it works in an entirely different way then the more advanced method of partitioning functions. Which are indeed only available in Developer and Enterprise versions.

    Here is an old script that I posted once on SQL ServerCentral.com to demonstrate partitioning at work using noting but several partition tables and a view to unify them as if they were one large table. And yes, you can insert in such views without writing any instead-of trigger on your part.

    Some not so obvious restrictions (there always are those, sigh):

    * When inserting records, you need to specify all columns, even those that accept NULL values.

    * You cannot do a modification trough the view when the query also uses a "select" that references the unified view or one of its patritions.

    The script is attached as a file for ease of use and contains some comments to help people on their way.