First Look at System-Versioned Temporal Tables-Part 2: Querying Data and Optimization Considerations

http://ift.tt/1ey5oWg

This article is the second part in a two-part series about system-versioned temporal tables—a new feature introduced in Microsoft SQL Server 2016. Part 1 covered what system-versioned temporal tables are, how to create them and how to modify data in them. This article focuses on querying data and optimization considerations.

read more

from SQL Server Pro http://ift.tt/1kCjeYg