Demo SQL Server 2008 DW - Configure DW Storage
- Posted: Jun 29, 2009 at 3:19 PM
- 10,949 Views
- 1 Comment
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- High Quality WMV (PC, Xbox, MCE)
- MP3 (Audio only)
- MP4 (iPod, Zune HD)
- Mid Quality WMV (Lo-band, Mobile)
- WMV (WMV Video)
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.
If you're having difficulty reading the scripts, please select a higher-res format for viewing.
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow 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
It's easy to find Microsoft DW whitepapers recommending a *single* file per filegroup, warning that proportional fill leads to file switching and hindered read-aheads.
Other sources, such as this video, advocate multiple files per filegroup.
Fast Track papers are content with a single filegroup (Primary), too, and recommend two files per RAID 1 LUN (~drive). Furthermore, the number of cores drives the number of LUNs (~drives).
Oddly, the SQL CAT team loves proportional fill striping, makes no mention of file switching, and only warns that proportional fill can hinder DW *load* times via smaller scatter/gather writes.
Remove this comment
Remove this thread
close