Try it with your next example it may save you a lot of time.

Instead of spending hours on creating sample databases, I will use the AdventureWorks database whenever I need just a database for my samples. To navigate around you should download the AdventureWorks OLTP Database Diagram for Visio: 4) On the expanded database view, go to Database Diagrams, do right click then choose. 3) Open SSMS then open and expand the AdventureWorks database (or any other database you want to generate the database diagram). The file size is small, but there are many tables inside this database. 2) Ensure you have restored AdventureWorks database (refer here for detail steps). Extended data warehouse (DW_Ext): with a lot more data (883 MB).Lightweight (LT): with a smaller set of data (7 MB).You can download a backup of the database for your version of SQL Server as part of the SQL Server Samples Repository. Thanks to the liberal license ( MIT license), you are allowed to use this database for whatever you like. With nearly 20.000 customers, over 70.000 orders and 500 products there is enough data for your examples. That stopped a few releases ago, but the database still does exist. Microsoft created a long time ago the fictitious multinational manufacturing company called Adventure Works and shipped the AdventureWorks database as part of SQL Server. They would work with any table, as long as there is just enough test data. However, most examples do not require handcrafted tables. The more time I spend with the setup, the less time I have to write the blog posts. Whenever I want to explain something that requires a database, I have to spend a lot of time to create the tables and test data before I even can start with the part I want to show.

Adventureworks 2012 database download