Ad‑hoc queries are everywhere. From ORMs and reporting tools to quick‑and‑dirty admin scripts and user‑driven search interfaces. They are convenient, flexible, and often unavoidable.
But behind that convenience lurks a complex world of plan cache bloating, parameter sniffing chaos, memory pressure, and unpredictable performance. This session dives deep into the mechanics, the pitfalls, and the best practices of working with ad‑hoc workloads in SQL Server.

Intermediate to Advanced. Attendees should have a working understanding of SQL Server execution plans, indexing, and basic performance troubleshooting. No prior knowledge of plan cache internals is required.