You should have a look at partitioning. IIRC as long as you have SP1 installed, you'll have access to this feature.
It took me a while to get the hang of this feature when I first encountered it, so I have a couple of articles on it:
Basic partitioning example
Autoamtic Data Purging with Partition Switching