THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server'

Execution plans, laundry, and a giveaway

This blog has moved! You can find this content at the following new location:

https://SQLServerFast.com/blog/hugo/2014/10/execution-plans-laundry-and-a-giveaway/

Published Saturday, October 25, 2014 12:57 AM by Hugo Kornelis

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Marc Schluper said:

Your SQL Mastery Session on Understanding Execution Plans matched the abstract very well.

I am looking forward to a session on How To Use Execution Plans To Improve Performance. It would be very practical, and introduce properties in the Execution Plan as they are needed to help improve performance. Rather than being complete and explaining even the rarest operator, it would address the properties most commonly needed to improve performance.

I am looking forward to receiving yesterday session's example code.

November 1, 2014 4:12 PM
 

Hugo Kornelis said:

Thanks for the feedback, Marc!

You are right that I don't focus on troubleshooting scenarios. I made a deliberate choice to focus on the building stones of the plan, and give the attendees the knowledge to understand both the individual elements, and the understanding of how they interact. Hence my analogy to learning language at the start.

My belief is that this knowledge may take more time to process and land, but once it does can be applied in more situations. Consider it a longer-term investment.

This is a very personal opinion, and your mileage may vary. But this is they way I have always liked to learn, and hence this is now also the way I like to teach.

But I do understand your feedback, and I will keep it in mind.

I have sent to the SQL Saturday organization a copy of the slides and a copy of the SSMS solution file with all the demo code (including the demos I had to skip for time reasons). I don't know whether they have already distributed this to the attendees, but if not they will undoubtedly do so later this week.

Thanks for your comment, and for attending my SQL Mastery Session! ;)

November 2, 2014 7:28 PM

Leave a Comment

(required) 
(required) 
Submit

About Hugo Kornelis

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to visit the SQL Server newsgroups, in order to share and enhance his knowledge of SQL Server.
Privacy Statement