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