Limitations of using Stretch Database

As you saw in the previous section, there are many limitations when you work with Stretch Database. You can distinguish between limitations that the prevent usage of Stretch Database and limitations in database tables that are enabled for stretching.

Limitations that prevent you from enabling the Stretch DB features for a table

In this section, you will see the limitations that prevent you from using Stretch DB. They can be divided into table, column, and index limitations.

Table limitations

You cannot enable the Stretch DB feature for any SQL Server table. A table should have stretch-friendly properties. The following list shows the table properties that prevent the use of the Stretch DB feature:

• It is a memory-optimized table
• It is a file table
• It contains FILESTREAM data
• It uses Change Data Capture or Change Tracking features
• It has more than 1,023 columns or more than 998 indexes
• Tables referenced with a foreign key
• It is referenced by indexed views
• It contains...