Demo SQL Server 2000/2005 Few Outer Rows Workaround

  • Posted: Jun 30, 2009 at 4:32 PM
  • By: Joe Longtin
  • Avg Rating: 0

  • 8,459 Views

Download

Right click “Save as…”

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Note: These selections will fall back to the next best format depending upon browser capability.

Close

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.

Tags:

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.