Nigel Rivett has a nice article about Partitioned Tables in SQL Server 2005. There are many samples and T-SQL scripts that reveal secrets of partitioned tables, schemes and indexes.
Adam Rink also has good post with samples about partition operations.