Sacramento SQL Server User Group

Next Meeting

Wednesday,

December

05

Improving the Performance of Functions - Eric Freeman

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Improving the Performance of Functions - Eric Freeman

Functions are stored blocks of code that can be reused in order to create simpler, more stable, and cleaner code. Functions can be great to have; however, they can also become a royal pain. Scalar and table valued functions can cause serious performance issues and the root cause may not be easy to find. In this session we will go over: (1) How to identify if a function is causing poor performance (with examples); (2) Methods that can be used to modify the function to greatly improve performance; (3) Improvements that come with SQL Server 2019 that may make you want to upgrade sooner rather than later.

Eric Freeman works as a Senior Business Intelligence Architect at John Burns Real Estate Consulting. He has over 15 years of experience working on Microsoft SQL Server and holds a MCTS in Business Intelligence with a strong emphasis on Performance Tuning, ETL and Data Warehousing. Former President of the Sacramento SQL Server User Group, and actively speaks at SQL Server events.

Meeting Sponsors:

Robert Half Technology
http://www.roberthalf.com/technology/

SentryOne
http://www.sentryone.com

Sacramento SQL Server User Group
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids