Time Travel Gotchas

Time Travel query offers a quick and intuitive way of querying your data for historical scenarios, as well as the traditional current picture. There are a number of good articles out there showing how to enable the feature and some suggestions on how to use it. But like nearly every option, it’s got pitfalls and overheads that will catch you out. I’m going to share a few that I’ve come across, specifically with reference to System Time. Business time has much less overhead than System Time, as there is no History table to be concerned about.