1. Intelligent QP features:
1.1 Scalar UDF inlining;
1.2 table variable deferred compilation;
1.3 Approx. count distinct;
1.4 Automatic tuning;
2. Automatic read-write connection re-routing 3. In-memory: memory-optimized tempdb