Joe Longtin
Joe Longtin
-
Demo SQL Server Star Join Query to Excel Pivot TableEric 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 typical DW query along with Microsoft Excel to create reports.
If you're having difficulty...
-
Demo SQL Server Manual Query Rewrites vs. Indexed View MatchingEric 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 capitalize on aggregates rather than rely on SQL Server's Query Optimizer, to generate more efficient...
-
Demo SQL Server Aggregate Query Rewrites with Indexed ViewsEric 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 performance for SQL Server 2000, 2005 and 2008, by taking advantage of indexed views.
If... -
Demo SQL Server 2008 Partition-aligned Indexed ViewsEric 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 tables. Partitioning and indexing now complement each other.
If you're having difficulty reading... -
Demo SQL Server 2008 Grouping SetsEric 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 aggregation. Using Grouping Sets reduces repetitive scans of the same data and improves performance. ...
-
Demo SQL Server 2000/2005 Few Outer Rows WorkaroundWhat 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.
If you're having difficulty reading the... -
Demo SQL Server 2008 Few Outer Row JoinsEric 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 joining dimensions to the fact table. Each outer row gets a separate thread on a nested loop...
-
Demo SQL Server 2008 Partitioned Table ParallelismEric 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 resources through intelligent parallel processing against partitioned tables. SQL Server automatically...
-
Demo SQL Server 2008 Star Join Query OptimizationEric 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 data model. Automatic star join query optimization dramatically improves performance by efficiently filtering...
-
Demo SQL Server 2008 Change Data CaptureEric 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.
If you're having difficulty...
Staff
Here is a list of Channel 9 staff members.
