← All presentations

A Practical Guide to Set-Based Queries

Download

Abstract

T-SQL queries, stored procedures, and poorly written functions are the main contributors 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 because many database developers started as procedural programmers. Also, many applications use SQL Server as data storage and do not take advantage of its incredible capabilities. This session will examine what set-based queries are, how to identify inefficient procedural processes, and how they can be rewritten as efficient set-based queries.

Presented at:

  • Day of Data Salt Lake City, Salt Lake City, UT on Sep 19, 2026
  • Postgres Conference 2025 (Pre-Con), Orlando, FL on Mar 18, 2025
  • PASS Data Community Summit 2024 (Pre-Con), Seattle, WA on Nov 6, 2024
  • Greater Lansing SQL Server (GLASS) & SQL PASS in Detroit (SPID), Michigan (Detroit & Lansing) on Jun 10, 2021 (virtual)