On March 23rd I will be presenting at SQL Saturday in Spokane WA.
There is still time to register for this event, so you can still sign up today.
My presentation will be on user defined Functions.
TSQL User Defined Functions – Taboo or not?
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
Level: Intermediate
For years user defined functions (UDFs) have been the nemesis of the DBA focused on performance, but they have been loved by developers due to their ability to help with code re-usability and abstraction of business rules. SQL Server 2019 introduces techniques that help eliminate some of the performance issues related to UDFs. Learn how and in what cases scalar UDF In-lining can improve your performance reducing the historic performance problems with UDFs. We will explore how in-lining improves performance, along with what you can do and what prevents in-lining of UDFs.
I hope to see you there.
Related Links:
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!