What is missing in SQL Server 2016?
SQL Server 2016 is the first SQL Server version that has some built-in support for temporal data. However, the support is still quite basic. SQL Server 2016 supports system-versioned tables only. You saw at the beginning of this chapter that application-versioned tables, and of course bitemporal tables, add much more to the complexity of temporal problems. Unfortunately, in order to deal with application validity times, you need to develop your own solution, including your own implementation of all the constraints you need to enforce data integrity. In addition, you need to deal with the optimization of temporal queries by yourself as well.
It would also be nice if you were able to define the retention period ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
