Use cases for Stretch Database

With so many limitations, finding use cases for Stretch DB does not seem to be an easy task. You would need tables without constraints and rare data types that are not involved in relations with other tables and that don't use some special SQL Server features. Where to find them? As potential candidates for stretching, you should consider historical or auditing and logging tables.

Archiving of historical data

Historical or auditing data is commonly produced automatically by database systems and does not require constraints to guarantee data integrity. In addition to this, it is usually in large data sets. Therefore, historical and auditing data can be a candidate for using the Stretch DB feature. SQL Server 2016 introduced support for system-versioned temporal tables. They are implemented as a pair of tables: a current and a historical table. One of the requirements for historical tables is that they cannot have any constraints. Therefore, historical tables used...