Author: Bartosz Ratajczyk
,, Database Developer and Trainer,
Stretch Databases and Temporal Tables in SQL Server 2016
Two new features in SQL Server 2016 make expanding your database’s historical data storage much easier. Here’s how to implement them. Storage. It’s a problem that anyone with a constantly-growing database has to face. We maintain great volumes of data that are rarely queried by business users. Most of these are historical or versioned data that someone checks once a year to see how “product X sales looked in 2005” or “record Z has changed over time”.