How to Use Parameters Like a Pro and Boost Performance - Part 2

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.

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?

We had so much to talk about  at the previous webinar, that we simply run out of time!

If you hadnt had the chance, you can listen to Part 1 on our YouTube channel

In this session we will learn about: 

• Parameters vs. Local Variables
• Changing Parameter Values
• Simple vs. Forced Parameterization

But most important! we will learn how to identify performance problems caused by poor parameter handling, and many techniques for solving these problems and boosting your application performance.

Presented by Guy Gluntser | CEO of Madeira Data Solutions 

Data Platform MVP, the leader of the Israeli PASS local group

Guy's career has been focused on the Microsoft Data Platform for more than 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.