Demo SQL Server 2008 Star Join Query Optimization
- Posted: Jun 30, 2009 at 2:17 PM
- 16,974 Views
Right click “Save as…”
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 filtering out non-qualifying fact table rows early in the query plan.
If you're having difficulty reading the scripts, please select a higher-res format for viewing.