Query Store is used to keep track of query performance.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |