How to Use Parameters Like a Pro & Boost Performance?
Updated: Sep 21, 2020
Does your query sometimes run fast and sometimes slow – even when nothing’s changed? Did it happen to you that a stored procedure, which had always been running for less than a second, suddenly started to run for more than 5 seconds consistently – even when nothing had changed?
Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren’t aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance.
In this webinar, Guy Glantser explains about plan caching and how the query optimizer handles parameters. The pros and cons of parameter sniffing (don’t worry if you don’t know what that means) as well as about simple vs. forced parameterization.
But most important! we discussed how to identify performance problems caused by poor parameter handling, and many techniques for solving these problems to boost your application performance.
for your continence, we recorded the training. Click on the video below to listen or go to our You Tube channel to find more training
You can find the training presentation and scripts here
We had so much to talk about that we run out of time! On September 3rd, we had the second part in which we focused on what happens when you change parameter values inside stored procedures, and also about the simple vs. forced parameterization modes.