Temporal Tables – Creation, Use and Optimizing

Dale Sullenberger

In this session, we will discuss when a temporal table is a good solution to use to deliver point-in-time results. We will learn how to create tables or convert current tables, as well as how to query the data from them. We will go over a few “watch out” items when querying from multiple tables, and discuss performance tips and options for ongoing operations, including the use of stretch database to hold older less frequently used data.