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.
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.
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
orChange 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...