For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.