This post is a response to the one of the most asked question where to get Sample Database for SQL Server 2008.
A few days ago, I received a DM asking What is an AdventureWorks database and why in all the examples I use that instead of any other database (e.g. Pubs or Northwind)? As a matter of fact, when I went back to my question list, which I have yet not answered, there were a few more variations of this same question.
Adventure Works is a Sample Database shipped with SQL Server and it can be downloaded from the http://www.codeplex.com/ site.
AdventureWorks have replaced Northwind and Pubs from the sample database in SQL Server 2005.
The Microsoft team keeps updating the sample database as they release new versions.
For SQL Server 2012 RTM Samples AdventureWorks Database is released:
You can download either of the data files and create database using the same. Here is the script which demonstrates how to create a sample database in SQL Server 2012.
Here is a quick video on this subject.
Here is a schematic of the Adventureworks.
Reference: Pinal Dave (http://blog.SQLAuthority.com)