Data Warehousing

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 is a Lead Program Manager for CORE RDBMS processing. He coordinated and worked on data warehouse scalability related improvements and details the benefits of these for customers. He also talks about some other new features in SQL Server 2008.

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 joining dimensions to the fact table.  Each outer row gets a separate thread on a nested…

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

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

Leo Giakoumakis is a Test Lead in the SQL Server team.  His team is responsible for the quality of query optimization, making sure that queries used in the new features are optimized properly and also that existing customers don’t see regression from their level of performance when upgrading…

Torsten Grabs is a Lead Program Manager on the SQL Server Engine Team. He discusses his work as a Lead Program Manager on Microsoft SQL Server 2008. He explains his contribution to Data Warehousing in SQL 2008, and its benefits to the customers. (Includes a white board example.) He also talks…

Alejandro worked primarily on scenario testing. His biggest challenges were the data warehousing scenarios.

Peter Zabback spricht über seine Arbeit als Entwickler und die wichtigsten Features an denen er mitgewirkt hat, wie zum Beispiel „Query Optimizer“. Er beschreibt die Herausforderungen in der Entwicklung und die Tatsache dass die Komplexität seiner Arbeit ständig zunimmt. Er gibt ausserdem einen…

As a Developer Lead on the Engine team Cesar worked on a number of new optimizations for SQL Server 2008.  The three biggest features were indexing for spatial and geographical data types, parallel execution for partitioned tables, and enhancements for star join processing.