(r.stropek) SQL Server 2005 now offers the possibility to partition tables and indexes. Using this feature can boost you DWH load. It will not necessarily enhance your query performance but it will make the typical tasks of loading the DWH DB easier.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help