SQL Server table partitioning for performance

SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

SQL Server 2008 Provides wizard for partitioning:
http://msdn.microsoft.com/en-us/library/dd578580.aspx