print @@version
/*
Microsoft SQL Server vNext (CTP2.0) - 15.0.1000.34 (X64) 
	Sep 18 2018 02:32:04 
	Copyright (C) 2018 Microsoft Corporation
	Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 17134: )
*/

elect * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_100'))
select * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_110'))
select * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_120'))
select * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_130'))
select * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140'))
select * from master..spt_values option(use hint ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150'))

ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF;

OPTION (USE HINT('DISABLE_TSQL_SCALAR_UDF_INLINING'))

CREATE OR ALTER FUNCTION ...
RETURNS ...
WITH INLINE = OFF

print @@version

	Microsoft SQL Server 2019 (CTP2.1) - 15.0.1100.94 (X64) 
	Nov  1 2018 14:35:49 
	Copyright (C) 2018 Microsoft Corporation
	Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 17134: )

use AdventureWorks2016CTP3;
go
select 
	count(*)
from
	Sales.SalesOrderDetail sod
	join Sales.SalesOrderHeader soh on soh.SalesOrderID = sod.SalesOrderID
group by
	soh.Status;
go
select 
	ps.query_plan
from
	sys.dm_exec_cached_plans cp
	cross apply sys.dm_exec_query_plan_stats(cp.plan_handle) ps
	cross apply sys.dm_exec_sql_text(cp.plan_handle) st
where
	st.text like '%SalesOrderDetail%' and
	st.text not like '%dm[_]exec[_]cached[_]plans%'
go