Sacramento SQL Server User Group

Attending PASS Summit 2019? Use discount code LGDIS6HUR to save $150 and support our group!


Next Meeting




Improving the Performance of Functions - Eric Freeman

  • Harvard Square (map)
  • 2180 Harvard Street, Suite 280 (Second Floor)
  • Sacramento, CA 95815
  • 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


Sacramento SQL Server User Group

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



Back to Top