http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/Niners/joe%20longtin/Entries, comments and threads posted by Joe Longtinhttp://channel9.msdn.com/Niners/joe%20longtin/en-usTue, 30 Jun 2009 22:15:25 GMTTue, 30 Jun 2009 22:15:25 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/7/4/3/6/7/4/ManualQueryRewritesvsQueryOpt_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.  <p> </p> <p>When should you manually rewrite queries to capitalize on aggregates rather than rely on SQL Server's Query Optimizer, to generate more efficient query plans? This screencast provides tips on how to experiment with both methods for best results. </p> <p> </p> <p>If you're having difficulty reading the scripts, please select a higher-res format for viewing. </p><p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Manual-Query-Rewrites-vs-Indexed-View-Matching/'>Demo SQL Server Manual Query Rewrites vs. Indexed View Matching</a></p><img src="http://channel9.msdn.com/476347/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Manual-Query-Rewrites-vs-Indexed-View-Matching/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Manual-Query-Rewrites-vs-Indexed-View-Matching/Wed, 01 Jul 2009 23:11:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/7/4/3/6/7/4/ManualQueryRewritesvsQueryOpt_ch9.wmv5934http://channel9.msdn.com/476347/WebViewBug.aspx?EVT=0<p>When should you manually rewrite queries to capitalize on aggregates rather than rely on SQL Server's Query Optimizer, to generate more efficient query plans? This screencast provides tips on how to experiment with both methods for best results.</p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Manual-Query-Rewrites-vs-Indexed-View-Matching/RSS/http://channel9.msdn.com/476347/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/1/5/3/6/7/4/StarJoinQuerytoExcelPivotTable_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key data warehousing features and functions of SQL Server.  <p> </p> <p>In this screencast, Eric uses a typical DW query along with Microsoft Excel to create reports. </p> <p> </p> <p>If you're having difficulty reading the scripts, please select a higher-res format for viewing. </p><p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/'>Demo SQL Server Star Join Query to Excel Pivot Table</a></p><img src="http://channel9.msdn.com/476351/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/Wed, 01 Jul 2009 23:11:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/1/5/3/6/7/4/StarJoinQuerytoExcelPivotTable_ch9.wmv6984http://channel9.msdn.com/476351/WebViewBug.aspx?EVT=0<p>In this screencast, Eric uses a typical DW query along with Microsoft Excel to create reports. </p> <p> </p>Joe Longtin1http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/RSS/http://channel9.msdn.com/476351/Trackback.aspxData Warehousingdemo seriesEric HansonReporting<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/9/3/3/6/7/4/PartitionAlignedIndexedViews_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. <br /> <br /> <p>Speed up query performance on very large fact tables. Partitioning and indexing now complement each other. </p> <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.  <p> </p><p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partition-aligned-Indexed-Views/'>Demo SQL Server 2008 Partition-aligned Indexed Views</a></p><img src="http://channel9.msdn.com/476339/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partition-aligned-Indexed-Views/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partition-aligned-Indexed-Views/Wed, 01 Jul 2009 23:10:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/9/3/3/6/7/4/PartitionAlignedIndexedViews_ch9.wmv5087http://channel9.msdn.com/476339/WebViewBug.aspx?EVT=0<p>Speed up query performance on very large fact tables. Partitioning and indexing now complement each other.  </p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partition-aligned-Indexed-Views/RSS/http://channel9.msdn.com/476339/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/3/4/3/6/7/4/AggregateQueryRewrites_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. <br /> <p> </p> <p>This technique helps you to accelerate query performance for SQL Server 2000, 2005 and 2008, by taking advantage of indexed views. </p> <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Aggregate-Query-Rewrites-with-Indexed-Views/'>Demo SQL Server Aggregate Query Rewrites with Indexed Views</a></p><img src="http://channel9.msdn.com/476343/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Aggregate-Query-Rewrites-with-Indexed-Views/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Aggregate-Query-Rewrites-with-Indexed-Views/Wed, 01 Jul 2009 23:10:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/3/4/3/6/7/4/AggregateQueryRewrites_ch9.wmv5064http://channel9.msdn.com/476343/WebViewBug.aspx?EVT=0<p>This technique helps you to accelerate query performance for SQL Server 2000, 2005 and 2008, by taking advantage of indexed views. </p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Aggregate-Query-Rewrites-with-Indexed-Views/RSS/http://channel9.msdn.com/476343/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/7/0/3/6/7/4/GroupingSets_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. <br /> <br /> <p>Simplify queries that require grouping or aggregation. Using Grouping Sets reduces repetitive scans of the same data and improves performance. </p> <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Grouping-Sets/'>Demo SQL Server 2008 Grouping Sets</a></p><img src="http://channel9.msdn.com/476307/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Grouping-Sets/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Grouping-Sets/Tue, 30 Jun 2009 23:33:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/7/0/3/6/7/4/GroupingSets_ch9.wmv5572http://channel9.msdn.com/476307/WebViewBug.aspx?EVT=0<p>Simplify queries that require grouping or aggregation. Using Grouping Sets reduces repetitive scans of the same data and improves performance.</p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Grouping-Sets/RSS/http://channel9.msdn.com/476307/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/6/0/3/6/7/4/FewOuterRowsWorkaround_small_ch9.png" border="0" /><p>What can I do if I am using SQL Server 2000 or 2005, and I want to do a more efficient join between a date dimension and a large fact table?<br /> <br /> Eric Hanson, principal program manager for SQL Server data warehousing, walks through creation of a workaround. </p> <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-20002005-Few-Outer-Rows-Workaround/'>Demo SQL Server 2000/2005 Few Outer Rows Workaround</a></p><img src="http://channel9.msdn.com/476306/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-20002005-Few-Outer-Rows-Workaround/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-20002005-Few-Outer-Rows-Workaround/Tue, 30 Jun 2009 23:32:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/6/0/3/6/7/4/FewOuterRowsWorkaround_ch9.wmv4604http://channel9.msdn.com/476306/WebViewBug.aspx?EVT=0<p>What can I do if I am using SQL Server 2000 or 2005, and I want to do a more efficient join between a date dimension and a large fact table? Eric Hanson, principal program manager for SQL Server data warehousing, walks through creation of a workaround.</p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-20002005-Few-Outer-Rows-Workaround/RSS/http://channel9.msdn.com/476306/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/4/0/3/6/7/4/FewOuterRowJoins_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. <br /> <br /> <p>Automatically leverage parallel processing when joining dimensions to the fact table.  Each outer row gets a separate thread on a nested loop join and all available cores share the workload. </p> <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Few-Outer-Row-Joins/'>Demo SQL Server 2008 Few Outer Row Joins</a></p><img src="http://channel9.msdn.com/476304/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Few-Outer-Row-Joins/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Few-Outer-Row-Joins/Tue, 30 Jun 2009 21:35:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/4/0/3/6/7/4/FewOuterRowJoins_ch9.wmv4626http://channel9.msdn.com/476304/WebViewBug.aspx?EVT=0<p>Automatically leverage parallel processing when joining dimensions to the fact table.  Each outer row gets a separate thread on a nested loop join and all available cores share the workload.</p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Few-Outer-Row-Joins/RSS/http://channel9.msdn.com/476304/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/1/0/3/6/7/4/PartitionedTableParallelism_small_ch9.png" border="0" /><p>Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. </p> <p>  </p> <p>Make the most of your available hardware resources through intelligent parallel processing against partitioned tables. SQL Server automatically assigns queries to all available threads. All cores share the workload equally to scan qualifying partitions, process and deliver results.</p> <p>If you're having difficulty reading the scripts, please select a higher-res format for viewing.</p><p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partitioned-Table-Parallelism/'>Demo SQL Server 2008 Partitioned Table Parallelism</a></p><img src="http://channel9.msdn.com/476301/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partitioned-Table-Parallelism/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partitioned-Table-Parallelism/Tue, 30 Jun 2009 21:18:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/1/0/3/6/7/4/PartitionedTableParallelism_ch9.wmv5148http://channel9.msdn.com/476301/WebViewBug.aspx?EVT=0<p>Make the most of your available hardware resources through intelligent parallel processing against partitioned tables. SQL Server automatically assigns queries to all available threads. All cores share the workload equally to scan qualifying partitions, process and deliver results.</p>Joe Longtin1http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Partitioned-Table-Parallelism/RSS/http://channel9.msdn.com/476301/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/3/2/1/6/7/4/StarJoinQueryOpt_small_ch9.png" border="0" /><p>Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. </p> <p>Get more performance out of your star schema data model. Automatic star join query optimization dramatically improves performance by efficiently filtering out non-qualifying fact table rows early in the query plan.<br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.</p><p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Star-Join-Query-Optimization/'>Demo SQL Server 2008 Star Join Query Optimization</a></p><img src="http://channel9.msdn.com/476123/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Star-Join-Query-Optimization/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Star-Join-Query-Optimization/Tue, 30 Jun 2009 21:17:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/3/2/1/6/7/4/StarJoinQueryOpt_ch9.wmv5307http://channel9.msdn.com/476123/WebViewBug.aspx?EVT=0<p>Get more performance out of your star schema data model. Automatic star join query optimization dramatically improves performance by efficiently filtering out non-qualifying fact table rows early in the query plan.</p>Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Star-Join-Query-Optimization/RSS/http://channel9.msdn.com/476123/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/2/2/1/6/7/4/ChangeDataCapture_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Use Change Data Capture to easily capture changes from your source database and accelerate ETL to the data warehouse. <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Change-Data-Capture/'>Demo SQL Server 2008 Change Data Capture</a></p><img src="http://channel9.msdn.com/476122/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Change-Data-Capture/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Change-Data-Capture/Tue, 30 Jun 2009 00:30:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/2/2/1/6/7/4/ChangeDataCapture_ch9.wmv4487http://channel9.msdn.com/476122/WebViewBug.aspx?EVT=0Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Use Change Data Capture to easily capture changes from your source database and accelerate ETL to the data warehouse.Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Change-Data-Capture/RSS/http://channel9.msdn.com/476122/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/8/4/5/5/7/4/DataCompression_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Watch video 3 to learn how data compression can easily save disk space and improve query performance. <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Data-Compression/'>Demo SQL Server 2008 Data Compression</a></p><img src="http://channel9.msdn.com/475548/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Data-Compression/http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Data-Compression/Mon, 29 Jun 2009 23:54:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/8/4/5/5/7/4/DataCompression_ch9.wmv5518http://channel9.msdn.com/475548/WebViewBug.aspx?EVT=0Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Watch video 3 to learn how data compression can easily save disk space and improve query performance.Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-2008-Data-Compression/RSS/http://channel9.msdn.com/475548/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/0/2/1/6/7/4/BackupCompression_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Video 4 is on accelerating backups with easy Backup Compression. <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Enterprise-Backup-Compression/'>Demo SQL Server 2008 Enterprise Backup Compression</a></p><img src="http://channel9.msdn.com/476120/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Enterprise-Backup-Compression/http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Enterprise-Backup-Compression/Mon, 29 Jun 2009 23:54:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/0/2/1/6/7/4/BackupCompression_ch9.wmv3294http://channel9.msdn.com/476120/WebViewBug.aspx?EVT=0Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Video 4 is on accelerating backups with easy Backup Compression.Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Enterprise-Backup-Compression/RSS/http://channel9.msdn.com/476120/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/6/4/5/5/7/4/ConfigureTempDBforDW_small_ch9.png" border="0" />Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Video 2 is on configuring TempDB for data warehousing. <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-DW-features-Configuring-tempdb-for-Data-Warehouse/'>Demo SQL Server 2008 DW: Configuring tempdb for Data Warehouse</a></p><img src="http://channel9.msdn.com/475546/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-DW-features-Configuring-tempdb-for-Data-Warehouse/http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-DW-features-Configuring-tempdb-for-Data-Warehouse/Mon, 29 Jun 2009 22:25:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/6/4/5/5/7/4/ConfigureTempDBforDW_ch9.wmv5943http://channel9.msdn.com/475546/WebViewBug.aspx?EVT=0Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Video 2 is on configuring TempDB for data warehousing.Joe Longtin0http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-DW-features-Configuring-tempdb-for-Data-Warehouse/RSS/http://channel9.msdn.com/475546/Trackback.aspxData Warehousingdemo seriesEric Hanson<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/5/9/3/5/7/4/ConfigureDataWarehouseStorage_small_ch9.png" border="0" />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. <br /> If you're having difficulty reading the scripts, please select a higher-res format for viewing.<p>in reply to <a href='http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Data-Warehousing-Features/'>Demo SQL Server 2008 DW - Configure DW Storage</a></p><img src="http://channel9.msdn.com/475395/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Data-Warehousing-Features/http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Data-Warehousing-Features/Mon, 29 Jun 2009 22:19:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/5/9/3/5/7/4/ConfigureDataWarehouseStorage_ch9.wmv5252http://channel9.msdn.com/475395/WebViewBug.aspx?EVT=0Eric 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.Joe Longtin1http://channel9.msdn.com/posts/Joe+Longtin/Demo-of-SQL-Server-2008-Data-Warehousing-Features/RSS/http://channel9.msdn.com/475395/Trackback.aspxdemo seriesEric Hanson