Demo SQL Server 2000/2005 Few Outer Rows Workaround

Embed code for this video

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

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

Right click “Save as…”

  • High Quality WMV (PC, Xbox, MCE)
  • MP3 (Audio only)
  • MP4 (iPod, Zune HD)
  • Mid Quality WMV (Lo-band, Mobile)
  • WMV (WMV Video)

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:

Follow the Discussion

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.