Here is a good article on SQL Server 2005 Partitioned Tables and Indexes.