Yes. It is a good idea.
It is called horizontal partitioning. The downside: you need the queries to be cognizant of the partitioning.
The result is much faster operation. You don't have to trip over past data constantly.
SQL 2005 has partitioning built in, whereby the query does not have to know about the partitioning at all.
Kalman Toth, Database Architect
The Best SQL Server 2005 Training in the World