offical SQL Server sample

offical SQL Server sample
http://msftdbprodsamples.codeplex.com/releases/view/55926

Release Notes

Sample Databases for Microsoft SQL Server 2008R2 (SR1)

This release is dedicated to the sample databases that ship for Microsoft SQL Server 2008R2. See Database Prerequisites for SQL Server 2008R2 for feature configurations required for installing the sample databases. See Installing SQL Server 2008R2 Databases for step by step installation instructions.

The SR1 release contains minor bug fixes to the installer used to create the sample databases. There are no changes to the databases themselves. If you have already successfully installed the AdventureWorks 2008R2 sample databases there is no need to install AdventureWorks 2008R2 SR1. This release has been updated to correctly handle the situation where the default instance is the only instance available.

All of the AdventureWorks sample databases for SQL Server 2008R2 are included in the self extracting zip file. When this zip file is run, all content is unzipped to a temporary directory and an installer application is automatically started. This application copies the database scripts and data files to the directory specified, and optionally installs sample databases. If some databases cannot be installed, a brief explanation is displayed and a link is provided for more information about how to resolve the installation issues.

The analysis services databases must be deployed manually using SQL Server Business Intelligence Development Studio after installation is complete. Please see Installing Analysis Services Database for more details.

The latest installer which is now available has better support for instances with different version of SQL Server, and also includes both the AdventureWorks 2008R2 schemas and data files and the original AdventureWorks schemas and data files which shipped with SQL Server 2005. Installing both AdventureWorks families will ensure that all samples will work correctly and that you'll be able to explore the new features in SQL Server 2008.

Update
Some users have been unable to successfully install the AdventureWorks2008R2 OLTP database using the SR1 installer. We have added a version of the database without FILESTREAM as a single file that you can download and attach. To install this version, go to AdventureWorks2008R2 without filestream.

Please give us your feedback in the samples forum! (Yes, even the complaints. We do try to respond to them.)