The DBA Fundamentals VC offers training and support to individuals interested in a solid DBA foundation.
Next Meeting

Tue, Mar 01 2016 11:00 (UTC-06:00) Central Time (US & Canada)

How to Use Parameters like a Pro and Boost Performance


How to Use Parameters like a Pro and Boost Performance

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.

Guy Glantser, SQL Server MVP, is the leader of the Israeli PASS chapter and also the CEO of Madeira. His career has been focused on SQL Server for the past 18 years, performing various database roles as either a DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, PASS Summit, SQL Rally, SQLBits and user groups around the world. He also co-hosts the SQL Server radio show.


JOIN PASS then add our Virtual Chapter to your list

Please join this chapter by creating a user account.  This can be accomplished by clicking here.  All registered users will be emailed detailed instructions prior to each meeting.  Thanks!  

Be a Speaker!

Share your knowlede and skill, become a speaker.  If you would like to speak at a future DBA Fundamentals event, please send us an email and we'll get back to you.  We are looking for professionals with level 100 presentations in a wide variety of database administration topics.  We look forward to hearing from you!!