My Session about SQL Server Parameterization

Guy-Glantser, 2017-05-10

 

Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Parameters Like a Pro and Boost Performance”.

 

Here is the abstract:

 

“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 important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.”

 

 

SQL Server Parameterization

 

If you are a developer writing code in SQL Server or if you are a SQL Server administrator, then this session is a must for you (that is, if you care about performance). You can watch the recording of the session here, and you can download all the session materials here.

 

I also wrote a complete series of blog posts about SQL Server Parameterization, which I recommend you to read:

 

  1. Plan Caching
  2. Seven Ways to Execute Your Query
  3. Parameter Sniffing
  4. Handling Non-Uniform Data Distribution
  5. Two Common Mistakes
  6. Simple vs. Forced Parameterization
  7. Summary

 

Happy performance tuning!

 

The post My Session about SQL Server Parameterization appeared first on Madeira Data Solutions.

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads