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 feature 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 DB-friendly properties. The following list shows the table properties that prevent the use of the Stretch DB feature:
- It is a memory-optimized ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
