Demo SQL Server Manual Query Rewrites vs. Indexed View Matching
[MP4] [0:02:45] [2009/07/02]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
When should you manually rewrite queries to…
Demo SQL Server Star Join Query to Excel Pivot Table
[MP4] [0:04:07] [2009/07/02]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key data warehousing features and functions of SQL Server.
In this screencast, Eric uses a…
Demo SQL Server 2008 Partition-aligned Indexed Views
[MP4] [0:08:38] [2009/07/02]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Speed up query performance on very large fact…
Demo SQL Server Aggregate Query Rewrites with Indexed Views
[MP4] [0:05:37] [2009/07/02]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
This technique helps you to accelerate query…
Demo SQL Server 2008 Grouping Sets
[MP4] [0:05:25] [2009/07/01]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Simplify queries that require grouping or…
Demo SQL Server 2000/2005 Few Outer Rows Workaround
[MP4] [0:04:42] [2009/07/01]
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…
Demo SQL Server 2008 Few Outer Row Joins
[MP4] [0:03:43] [2009/07/01]Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Automatically leverage parallel processing when…
Demo SQL Server 2008 Partitioned Table Parallelism
[MP4] [0:05:43] [2009/07/01]
Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Make the most of your available hardware…
Demo SQL Server 2008 Star Join Query Optimization
[MP4] [0:03:58] [2009/07/01]
Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Get more performance out of your star schema…
Demo SQL Server 2008 Change Data Capture
[MP4] [0:07:32] [2009/06/30]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…
Demo SQL Server 2008 Data Compression
[MP4] [0:06:51] [2009/06/30]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…
Demo SQL Server 2008 Enterprise Backup Compression
[MP4] [0:03:21] [2009/06/30]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…
Demo SQL Server 2008 DW: Configuring tempdb for Data Warehouse
[MP4] [0:05:05] [2009/06/30]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…
Demo SQL Server 2008 DW - Configure DW Storage
[MP4] [0:03:40] [2009/06/30]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…