The following changes have been made in the design of AdventureWorksDW2008:
  • The DimTime table has been renamed DimDate since the table actually contains dates rather than times.
  • The key has been changed to DateKey and it is now an integer in the form YYYYMMDD rather than a surrogate key.
  • The new date datatype is used in the DimDate table.
  • Some columns such as CalendarYear in the DimDate table have been change to int from char(4) since the data in those columns is numeric.
  • Some columns such as CalendarYear have changed to NOT NULL from NULL in order to improve query performance.
For specific information about these changes a relational schema diagram, a Transact-SQL script and the CSV data files necessary to build the database are included in the AdventureWorks2008Scripts.msi installer located in The Sample Databases at CodePlex project.

Last edited Feb 27, 2008 at 7:22 PM by bonniefe, version 2

Comments

vitorcaldas Mar 19, 2012 at 7:13 PM 
Microsoft need to update the Analysis Services tutorial page or maintain the previous database sample files.

kumra Nov 16, 2011 at 9:41 PM 
I cannot find the AdventureWorksDW2008???????????

smaziano Jul 9, 2010 at 8:18 AM 
What about AdventureWorksDW2008 ??

pinkchan Mar 28, 2008 at 6:33 AM 
s