Dmitry Pilugin's Notes

Sample DBs

Database opt

Database OPT is a simple synthetic database containing three tables t1, t2, t3 – 1000 rows each and used for the demonstration purposes.
Script opt:

use master;
go
if db_id('opt') is not null drop database opt;
go
create database opt;
go
use opt;
go
create table t1(a int not null, b int not null, c int check (c between 1 and 50), constraint pk_a primary key(a));
create table t2(b int not null, c int, d char(10), constraint pk_b primary key(b));
create table t3(c int not null, constraint pk_c primary key(c));
go
insert into t1(a,b,c) select number, number%100+1, number%50+1 from master..spt_values where type = 'p' and number between 1 and 1000;
insert into t2(b,c) select number, number%100+1 from master..spt_values where type = 'p' and number between 1 and 1000;
insert into t3(c) select number from master..spt_values where type = 'p' and number between 1 and 1000;
go
alter table t1 add constraint fk_t2_b foreign key (b) references t2(b);
go
create statistics s_b on t1(b);
create statistics s_c on t1(c);
create statistics s_c on t2(c);
create statistics s_d on t2(c);
go

Adventure Works 2012-2016CTP

The Adventure Works DB is a sample Microsoft database of the imaginary company Adventure Works Cycles. Adventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are based, is a large, multinational manufacturing company. The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. While its base operation is located in Bothell, Washington with 290 employees, several regional sales teams are located throughout their market base.

Adventure Works 2012
Adventure Works 2014
Adventure Works 2016CTP

Description for Adventure Works 2008 (may give you an idea about the data):
AdventureWorks Sample Databases (MSDN)

WideWorldImporters: The new SQL Server sample database

New Microsoft Sample DB – WideWorldImporters.

Leave a comment