Posted by Enorme Vigenti on 10/17/07 07:21

Erland Sommarskog ha scritto:

> Had you been on SQL 2005, you could have used partitioned tables. This
> requires Enterprise Edition, I should hasten to add. With partitioned
> table, deleting old data can be as smooth as a metadata operation,
> if you set it up correctly.
>
> On SQL 2000 (and SQL 2005 Standard and lower editions) you can use
> partitioned views. This requires some more work, but is still doable.
> And again the delete can be as simple as dropping the table.
>
> SQL Server MVP Stefan Delmarco has a good article on partitoned views
> on http://www.fotia.co.uk/fotia/FA.02.Sql2KPartitionedViews.01.aspx.
>
Many thanks :-)
Very good!

[Back to original message]