This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server 2016 introduced a new sample database which is Wide World Importers (WWI), and it is an OLTP/OLAP database and aims to give a demonstration of the SQL Server 2016 capabilities and performance enhancements.
You can download full backup here
Database “WideWorldImporters” is OLTP, and following are main features:
- Query Store
- Nonclustered columnstore indexes
- Partitioning
- With temporal tables
- JSON integration
- Row level security
- Data masking
- Always Encrypted
- Clustered columnstore indexes
Database “WideWorldImportersDW” is OLAP, and following are main features:
- Polybase
- Clustered columnstore indexes
- Partitioning
- In-memory OLTP
Leave a Reply