Demo SQL Server 2000/2005 Few Outer Rows Workaround

Posted By: Joe Longtin | Jun 30th @ 4:32 PM | 4,616 Views | 0 Comments

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.
Rating:
0
0
Be the first to comment!
Microsoft Communities