Demo SQL Server 2008 DW - Configure DW Storage

Description

Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Video 1 is on configuring DW storage.
If you're having difficulty reading the scripts, please select a higher-res format for viewing.

The Discussion

Great topic, but what was the rationale for assigning multiple (four) data files to a single filegroup?

Let's assume:
• a desire to favor query performance (i.e., sequential I/O) over load times
• a willingness to assign a filegroup to each fact table
• fact tables are 'properly loaded' to facilitate sequential I/O, and have a clustered key
• we ignore tempdb