SLC SQL Server User Group May Meeting

Are you going?

16 people going

Share:

Every 2nd Monday of the month until January 12, 2020

Location image of event venue

Details

May SLC SQL Meeting - IMED DOTY AUD EAST

Presentation by: Aaron Cutshall - Tally Tables

Abstract

Because SQL Server is designed to efficiently operate with set-based queries, it does not perform as well with loops and cursors. However there are situations where you really need some type of a loop. Tally tables give you the best of both worlds by allowing you to effectively "loop" through records in a set-based manner. We'll explore what tally tables are, how they work, and more importantly review some of the many ways you can use them to turn your loops and cursors into efficient set-based operations.

Bio

Aaron N. Cutshall is a Sr. Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 12 years in the Healthcare Informatics field. His primary focus has been in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQL Saturday sessions across the country.