This project is read-only.
AdventureWorksDW 2008R2 Details
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.
AdventureWorksDW 2008R2 Installation
Please see Installing SQL Server 2008R2 Databases for information about how to install the AdventureWorksDW2008R2 database.

Last edited May 25, 2010 at 10:24 PM by bonniefe, version 5


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

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

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

pinkchan Mar 28, 2008 at 7:33 AM