May SLC SQL Meeting - IMED DOTY AUD EAST
Presentation by: Aaron Cutshall - Tally Tables
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.
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.