SQL 2K

I am creating a table for holding data used for data wear-housing project.
This table will eventually going to have millions of records.
Planned to have a primary key and proper indexing in this table.
This table will be queried against various columns and will be refreshed
(fill data) on a weekly basis.

Is there any other approach I should think about like - Partitioned views or
??

Any thoughts/Ideas will be highly appreciated.

Thanks
Sh