• This article might give you some ideas... Partitioning in SQL Server[/url]

    It sounds like this is a good use for it, but I'm not a partitioning expert... and it depends on the version of SQL Server you're using.