top of page

How to Use Parameters Like a Pro and Boost Performance

יום ג׳, 04 באוג׳

|

Guy Glantser

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?

Registration is Closed
See other events
How to Use Parameters Like a Pro and Boost Performance
How to Use Parameters Like a Pro and Boost Performance

Time & Location

04 באוג׳ 2020, 11:00 – 12:30 GMT‎+3‎

Guy Glantser

Guests

About the event

 

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?

In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about 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…

Share this event

bottom of page