info@techdevops.com | 437-991-3573 | Data Tier Services
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, ERP, Performance & Cloud



Determine if your current UDFs are inlineable to benefit from SQL Server 2019 performance boost
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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%'