Eric Hanson | Tags

8 minutes, 38 seconds

Demo SQL Server 2008 Partition-aligned Indexed Views

Joe Longtin Jul 01, 2009 at 4:10 PM

0

(1)

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…

3 minutes, 43 seconds

Demo SQL Server 2008 Few Outer Row Joins

Joe Longtin Jun 30, 2009 at 2:35 PM

0

(1)

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…

4 minutes, 42 seconds

Demo SQL Server 2000/2005 Few Outer Rows Workaround

Joe Longtin Jun 30, 2009 at 4:32 PM

0

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…

3 minutes, 21 seconds

Demo SQL Server 2008 Enterprise Backup Compression

Joe Longtin Jun 29, 2009 at 4:54 PM

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

4 minutes, 26 seconds

SQLServerColumnStoreIndex

Apr 28, 2011 at 3:08 PM

0

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