(605) SQL Server User Group

Meeting: Tue, Feb 11 2020

February 2020 Meeting

This monthy meeting will have a presentation on various in memory objects by Phil Podhradsky and Sam Miller.


When:

Tue, Feb 11 2020 Event Time: 05:30 - 07:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Tue, Feb 11 2020 11:30 - 13:30
iCal


RSVP: https://www.surveymonkey.com/r/8HJ8WPF


Where:

300 N Cherapa Place - Sioux Falls, South Dakota (map)

Please park on the east side of the building. The meeting will be held on the 3rd floor conference room and the elevators will be configured to allow you to get to the 3rd floor without assistance.



Featured Presentation

Temp tables, Table Variables, Table Valued Functions, CTEs, User Defined Table Types – What does it all mean???

Speaker: Phillip Podhradsky, Data Architet\DBA Fishback Financial Corporation

Summary: There are many choices for temporary data structures in SQL server. We are going to discuss some of the options that are available. We will touch on the pros and cons of each, as well as the performance implications. Finally, we will go over how to tie these into your development/ETL toolbox to help create the most efficient data movement as possible and avoid row-by-row processing if at all possible.

 

About Phillip: SQL Server DBA at Fishback Financial Corporation. I have been working with with SSRS, SSAS, SSIS, and the SQL server database engine from SQL 2005 on up since 2007. Some of my main focuses are to troubleshoot performance issues, disaster recovery, and support various application development initiatives.

Temp tables, Table Variables, Table Valued Functions, CTEs, User Defined Table Types – What does it all mean???

Speaker: Sam Miller, Data Warehouse Manager EDCO Health Information Solutions

Summary: There are many choices for temporary data structures in SQL server. We are going to discuss some of the options that are available. We will touch on the pros and cons of each, as well as the performance implications. Finally, we will go over how to tie these into your development/ETL toolbox to help create the most efficient data movement as possible and avoid row-by-row processing if at all possible.

 

About Sam: Data warehouse and software architect with 15+ years of experience in creating innovative MS SQL Server database driven solutions for various industries including health care, education, and wholesale distribution, and retail e-commerce.


Attachments:

  • Temporary Data Structures.pdf
  • Temporary Data Structures February 2020.sql
  • SqlPass_UDTT_Demo.sql
  • LoadResultsIntoTableWithParams.cs
  • Meeting Archive

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