Some databases you can download from this repository: https://rebrand.ly/sample-db
| 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 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 | - | ? | ? |
- Data.gov
- Amazon product data (This dataset contains product reviews and metadata from Amazon, including 142.8 million reviews spanning May 1996 - July 2014)
- 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)