A Practical Guide to Set-Based Queries

Abstract:
T-SQL queries, stored procedures, and functions that are poorly written is the main contributor to performance degradation in SQL Server. SQL Server is optimized for set-based processing over procedural processing.

The sad reality is that too much code is written from a procedural point of view due to the fact that many database developers started out as procedural programmers. Also, many applications merely use SQL Server as a data storage and do not take advantage of it’s incredible capabilities. This session will take a look at what set-based queries are, how to identify inefficient procedural processes, and how they can be re-written as efficient set-based queries.

Bio:
Aaron Cutshall has almost 40 years of experience in systems design, databases and architecture. For 20 years he worked in the manufacturing, warehouse, distribution before moving to healthcare. His specialty is in performance architecture and tuning for extremely large data sets.

Agenda:
6:00-6:30 - Networking and speaker setup time
6:30-6:35 - Opening remarks & Introductions
6:35 - Speaker time!