Download this episode
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 the scripts, please select a higher-res format for viewing.
Available formats for this video:
Actual format may change based on video formats available and browser capability.