The first challenge is getting a server and storage solution that works well for large data warehouses. It's extremely tricky to build one from scratch, and extremely expensive to get the multiple GBs throughput you'll need for a good solution from
a traditional enterprise SAN.
So definitely look at the
Fast Track Reference Architecture solutions. These are cost-effective Data Warehouse solutions engineered in partnership between the SQL Server Data Warehouse team and the hardware vendors. They are "balanced" systems having the right
amount of CPU, memory and storage throughput for a SQL Server Data Warehouse solution.
Having a DW platform that can scan a very large table quickly, and having the CPU power to process large amounts of data makes all the downstream design decisions easier.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.