info@techdevops.com
|
437-991-3573
|
Data Engineering Services
TechDevOps.com
Resources
Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance
Determine if your current UDFs are inlineable to benefit from SQL Server 2019 performance boost
by BF (Principal Consultant; Architecture; Engineering)
2020-11-28
< Back
T-SQL Solution:
Select o.name, m.is_inlineable
from sys.sql_modules m
inner join sys.objects o on o.object_id = m.Object_id
where o.name like 'ufn%'