Sql server express adventureworks database 2016

#Sql server express adventureworks database 2016 archive#

Temporal tables are used to conveniently keep track of the history of reference data, as well as some of the main entities.Query Store is used to keep track of query performance.

#Sql server express adventureworks database 2016 archive#

Archive tables can be stretched to Azure for long-term retention, reducing storage cost and improving manageability.

Real-time operational analytics of sales data is enabled through the use of nonclustered columnstore indexes.

Here are some examples of the use of SQL Server capabilities with this database:

WideWorldImporters is the main database for transaction processing (OLTP вЂ“ OnLine Transaction Processing) and operational analytics (HTAP вЂ“ Hybrid Transactional/Analytics Processing).

Latest release of the sample: wide-world-importers-releaseДocumentation for the sample: wide-world-importers-documentation

It also showcases the key SQL Server 2016 capabilities and performance enhancements. It does not attempt to use every single SQL Server feature, as that would not be realistic. It illustrates how the rich SQL Server feature set can be used in a realistic database.

Wide World Importers is the new sample for SQL Server. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade. This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server.ДЄ release the magnitude of SQL Server 2016 deserves a new sample.