SQL Server Sample Databases14 Jun 2010
Updated AdventureWorks sample databases for SQL Server 2008R2 now on codeplex and include OLTP, data warehouse and analysis services examples.
From the site:
· The Adventure Works OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
· The Adventure Works DW database demonstrates how to build a data warehouse.
· The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
· The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.