SQL Server: performance tuning

Intelligent Query Processing (IQP)

IQP features include

Batch mode adaptive joins (dynamically select join type at runtime based on input data)
approximate count distinct (SQL aggregate function approx_count_distinct)
batch mode for row store
Interleaved execution for multi-statement table valued functions
memory grant feedback (batch mode)
memory grant feedback (row mode)
scalar UDF inlining
table variable deferred compilation

alter database tq84_db set compatibility_level = 150;