![]() ![]() This means our data in our sample database is no longer static and can be changed whenever we need new data. In other words, you can build a DataMart from WorlWideImporters and then simulate new workloads in the sample database which you can run daily. The new sample database has and is still being built to be able to run new workloads. 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. 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. ![]() 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. 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”. 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. Ever since we have been using this new sample database for almost everything we want to test. 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. Almost every code sample on books online references AdventureWorks for illustrations and practical explanations of a feature. Almost every demo or presentation pertaining to SQL Server we do, we use the AdventureWorks sample database. ![]() We have all learned to love and hate the trusty Bike shop database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |