Parameters in SQL Server - Query Performance Makers or Breakers

Mindy Curnutt
60 minutes
Application & Database Development
T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad-hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues. Have you experienced a query that always ran fast, suddenly (and for "no reason") become slow? And with nothing changing? Yep! * In this session we will learn about how the plan cache deals with queries that are (and are not) parameterized. * You'll learn about parameter sniffing, what it is, and how it's handled in the older and newest versions of SQL. * We will explore the problem of mismatched data types and implicit conversions - and how that ties in with ORM generated code. * Lastly, we'll take a peek at value list handling from applications, and how using a table valued parameter as an input instead. If this is a new topic to you, you'll leave this session with takeaways galore.

Accompanying Material

No material found.

Back to Top cage-aids