Loading...

How to use Parameters like a Pro and Boost Performance

847 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 1, 2016

Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, dynamic statements, or ad hoc queries. Although widely used, most people aren't aware of the crucial influence parameters have on query performance. In fact, incorrect use of parameters is one of the common reasons for poor application performance.
In this session, you learn about plan caching and how the Query Optimizer handles parameters. We talk about the pros and cons of parameter sniffing, as well as simple versus forced parameterization. But most important, we learn how to identify performance problems caused by poor parameter handling and we learn many techniques for solving these problems and boosting your application performance. Hosted by Steve Cantrell of DBAFundamentals

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...