SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

How to Use Parameters Like a Pro and Boost Performance

Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals PASS Virtual Chapter. I love this session, because it’s based on my experience with so many clients in so many cases. I see the same mistakes that developers do again and again, and with some simple “tricks”, you can really boost performance. You just need to understand how parameterization works in SQL Server, and how to handle them correctly. And this is what this session is all about.

I promised to share the presentation and all the scripts that I used in the session, so here they are:

zip

Parameterization
You can also check out a blog series I wrote about this topic. This blog series covers more or less the same subjects I covered in the session.

If you have any questions about this topic, then feel free to ask them in the comments of this post, or find me on Twitter at @guy_glantser.

The post How to Use Parameters Like a Pro and Boost Performance appeared first on .

Guy Glantser

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 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.

Comments

Leave a comment on the original post [www.madeiradata.com, opens in a new window]

Loading comments...