Abstract
There are many current practices employed when developing queries, views, procedures, and functions that can affect performance. Yes, database engines can be tuned, indexes adjusted, and server settings tweaked, but none of them will overcome bad code. Often, habits and practices begin early in a career and tend to stick with us throughout all subsequent projects unless addressed. This includes:
- Improper selection criteria
- Inefficient joins
- Implicit conversions
- Using procedural processing instead of set-based methods
Surprisingly, the impacts from these practices impact many different platforms alike: SQL Server, Postgres, Snowflake, Redshift, etc. This session will cover the most common and most expensive performance issues found in code out in the wild and what you can do instead to make your code perform its very best!
Presented at:
- Day of Data Vancouver, Vancouver, WA on November 7, 2026