Sample_Databases

SQL Server Sample Databases and Datasets

Some databases you can download from this repository: https://rebrand.ly/sample-db

Sample databases information

Name / Download links	SQL Server Version	Type	.Bak, MB	.Mdf, MB	Table count
StackOverflow 2010 Database	>=2012	OLTP	9360	9104	9
StackOverflow Database	>=2012	OLTP	137000		9
StackOverflow Column Store Edition	>=2017	OLTP	160000		9
WideWorldImporters OLTP	?	OLTP	121	1024	29
WideWorldImporters OLTP Legacy	>=2008	OLTP	64	391	31
WideWorldImporters DWH	?	DWH	47	2048	48
AdventureWorks OLTP 2017	2017	OLTP	47	264	71
AdventureWorks OLTP 2016	>=2016	OLTP	93	208	96
AdventureWorks OLTP 2016 Extended	>=2016	OLTP	125	386	71
AdventureWorks OLTP 2014	>=2014	OLTP	44	205	71
AdventureWorks OLTP 2012	>=2012	OLTP	44	192	71
AdventureWorks DWH 2017	>=2017	DWH	22	136	31
AdventureWorks DWH 2016	>=2016	DWH	21	170	31
AdventureWorks DWH 2016 Extended	>=2016	DWH	883	1466	33
AdventureWorks DWH 2014	>=2014	DWH	21	170	31
AdventureWorks DWH 2012	>=2012	DWH	21	124	31
AdventureWorks Multidimensional Model	?	AS	21	?	?
AdventureWorks Tabular Model	?	AS	21	?	?
Northwind Database	2000	OLTP	-	?	?
Pub Database	2000	OLTP	-	?	?
Oracle Employee Database	2000	OLTP	3	4	2
DunderMifflin	?	OLTP	-	-	?

Datasets

• Data.gov
• Amazon product data (This dataset contains product reviews and metadata from Amazon, including 142.8 million reviews spanning May 1996 - July 2014)

Useful Links

• AdventureWorks Sample Databases and Scripts for SQL Server 2017, 2016, 2014 , 2012
• AdventureWorks for Analysis Services
• AdventureWorks Sample Databases and Scripts for SQL Server 2008 R2
• Microsoft SQL Server 2008 R2 SR1 Sample Databases
• Thinking Big (Adventure) (by Adam Machanic)
• WideWorldImporters Sample Database (Github Microsoft)
• IoT Smart Grid sample - demonstrates how SQL Server 2016 memory optimized databases could be used to ingest a very high input data rate (Github Microsoft)
• In-Memory OLTP (WWI Sales Orders) (Github Microsoft)
• Bigger Fact Table for Wide World Importers (by Koen Verbeeck)
• Contoso Retail Data Warehose (Github)
• How to Download the Stack Overflow Database via BitTorrent 2016-03 (by Brent Ozar)
• Stack Overflow Database version 2016-12-15
• Stackexchange Source files - xml files
• Git repo for SQL Server Reporting Services samples and community projects
• SQLSkills sample databases (also include SAMPLE CORRUPT DATABASES)
• SQLIndexWorkbook Sample Database (by Little Kendra)
• Itzik Ben-Gan Sample Databases (by Itzik Ben-Gan)
• Orders: Open Source Sample Database (by Brent Ozar)
• BabbyNames Database (by Kendra Little)
• SQL Server Sakila DB (by jOQO)