Eric Hanson

Watch this video from SQL Server Principal Program Manager in query processing team, Eric Hanson, on Column Index in upcoming SQL Server "Denali"

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 resources through intelligent parallel processing against partitioned tables. SQL…

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 data model. Automatic star join query optimization dramatically improves performance by efficiently…

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 typical DW query along with Microsoft Excel to create reports.   If you're having…

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 capitalize on aggregates rather than rely on SQL Server's Query Optimizer, to generate more…

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. If you're having difficulty reading the scripts, please select a higher-res format for…

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.

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 performance for SQL Server 2000, 2005 and 2008, by taking advantage of indexed views. …

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 tables. Partitioning and indexing now complement each other. If you're having difficulty…

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. If you're having…