snippetsqlMinor
Where clause to filter rows for Azure Stretch Database?
Viewed 0 times
rowsstretchwheredatabasefilterazureforclause
Problem
Currently stretch database in SQL Server 2016 moves the entire table to Azure. However, this InfoQ article mentions an "archive row" mode for Stretch database that will allow you to filter which rows in a table to move to the cloud (ex. records before 2010). I haven't been able to find any official Microsoft documentation regarding this unreleased feature.
Can someone point me to an official source that says this is coming for RTM? I did find a French blog entry on MSDN mentioning it but nothing else.
Can someone point me to an official source that says this is coming for RTM? I did find a French blog entry on MSDN mentioning it but nothing else.
Solution
Documented now for the latest CTP release. See how to write a TVF that a filter predicate uses to define what is a cold row (that gets moved) in a table with a mix of hot & cold rows: https://msdn.microsoft.com/en-us/library/mt613432.aspx
Context
StackExchange Database Administrators Q#120089, answer score: 2
Revisions (0)
No revisions yet.