Skip to content

Latest commit

 

History

History

Sample_Databases

Folders and files

NameName
Last commit message
Last commit date

parent directory

..

Create_Enlarged_Adventureworks_Tables.sql

Create_Enlarged_Adventureworks_Tables.sql

 
 

Database_script.sql

Database_script.sql

 
 

Oracle_Employee_Database.sql

Oracle_Employee_Database.sql

 
 

PerformanceV3.sql

PerformanceV3.sql

 
 

README.md

README.md

 
 

TSQLV4.sql

TSQLV4.sql

 
 

README.md

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