info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools Services
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








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%'