新SQL Server 2016示例数据库

背景 (Background)

We have all learned to love and hate the trusty Bike shop database. Almost every demo or presentation pertaining to SQL Server we do, we use the AdventureWorks sample database. Almost every code sample on books online references AdventureWorks for illustrations and practical explanations of a feature. When SQL Server 2005 was released Microsoft replaced the old Pubs & Northwind Sample databases with a more complete and more feature rich database called AdventureWorks. Ever since we have been using this new sample database for almost everything we want to test. Microsoft has now given us an even better sample database called WorldWideImporters, which utilises almost every SQL Server feature I can think of from Temporal Tables to In-Memory table.

我们都学会了爱与恨可信赖的自行车商店数据库。 几乎每个与SQL Server有关的演示或演示都使用AdventureWorks示例数据库。 联机丛书上的几乎所有代码示例都参考AdventureWorks，以获取功能的插图和实际说明。 当SQL Server 2005发布时，Microsoft用名为AdventureWorks的更完整，功能更丰富的数据库替换了旧的Pubs＆Northwind Sample数据库。 自从我们一直将这个新的示例数据库用于几乎我们要测试的所有内容。 微软现在为我们提供了一个更好的示例数据库，称为WorldWideImporters，该数据库利用了我能想到的几乎所有SQL Server功能，从临时表到内存表。

讨论区 (Discussion)

When SQL Server 2016 was still in the CTP phases I wanted to play with all the new features and see what I can use it for in the “real world”. I know SQL Server always has this awesome new features, but I do not always have the resources or opportunities to play with this in a “real world” scenario. A good example of this is In-Memory tables, I know of them and I have created a few In-Memory tables in SIT to demonstrate the speed enhancements but it always gets turned down due to a concern of excessive memory usage.

当SQL Server 2016仍处于CTP阶段时，我想使用所有新功能，并了解如何在“现实世界”中使用它。 我知道SQL Server总是具有这些令人敬畏的新功能，但我并不总是有资源或机会在“现实世界”中使用它。 内存表就是一个很好的例子，我知道它们，并且在SIT中创建了一些内存表来演示速度的提高，但是由于担心过度使用内存，它总是被拒绝。

The new WorldWideImporters database offers us the ability to really test and play with all the new features as well as use it for simulations. The new sample database has and is still being built to be able to run new workloads. In other words, you can build a DataMart from WorlWideImporters and then simulate new workloads in the sample database which you can run daily. This means our data in our sample database is no longer static and can be changed whenever we need new data. This is exciting stuff because now I can brush up on my ASP skills and built web front ends and see how data changes would affect the performance of my application.

新的WorldWideImporters数据库使我们能够真正测试和使用所有新功能，并将其用于仿真。 新的示例数据库已经并且正在构建，以便能够运行新的工作负载。 换句话说，您可以从WorlWideImporters构建DataMart，然后在示例数据库中模拟新的工作负载，您可以每天运行这些工作负载。 这意味着我们样本数据库中的数据不再是静态的，可以在需要新数据时进行更改。 这是令人兴奋的事情，因为现在我可以提高ASP技能并构建Web前端，并查看数据更改将如何影响应用程序的性能。

I have added below an image of the database diagram for the n