THE SQL Server Blog Spot on the Web

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

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

Give speakers feedback. It makes a difference.

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

Published Saturday, October 25, 2014 11:19 PM 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



ALZDBA said:

Great feedback processing, Hugo.

I attended that session and enjoyed it very much.

Whatever you do and however you rework it, please keep the last comparison of the queries as they used to be (especially the SQL2000 one !) and how the over-clause(-evolution) simplifies it all !


October 27, 2014 4:41 AM

Hugo Kornelis said:

Thanks for your comment, Johan! I am glad that you liked my presentation!

I can promise that the 2.5 version will still have the comparisons between old (2000 and before), in between (2005 - 2008R2), and new (2012 and up).

Not sure about the 3.0 version, if there is going to be one. I, too, like contrasting the queries (especially the one at the end that combines all techniques). But it has to fit in the flow and the buildup of the total session. If I am going to rewrite from scratch, I have to be prepared to, as I've heard book authors call it, "kill my darlings".

October 27, 2014 2:00 PM

David Williams (justdave) said:

Good to see someone showing how they use feedback!

November 3, 2014 5:24 PM

Rich said:

I'm nowhere near on your level Hugo, and I think you have courage to publicly discuss where a presentation you gave went off the rails a bit.  Congratulations!

It sounds formulaic, but one way I've dealt with situations like this -- where you have a lot of messy, complicated subject matter that is relevant in its entirety, but not in the details -- is to say exactly that beforehand:

"These queries used to be ugly to write and slow to perform in SQL 2000.  I'm going to quickly flash a few examples up on the screen for you, without walking through the logic of them specifically. I'll highlight major code sections, then quickly move on to how windowing functions do the job better."

That way you can walk them through the history, give them the details in the slide deck if they want to reproduce it themselves later, but not get mired down.

If this is appropriate, you could even brightly color-shade or somehow annotate various blocks of the T-SQL (not with SSMS, using bold color backgrounds or arrows or something) the main 2 or 3 sections of the SQL 200 queries.  Maybe you could color the background of a correlated subquery in bright blue with a note: "This gets the top 2 rows for each group and joins back to the main query."

Just brainstorming here.  I ALWAYS learn something from your posts on SSC -- thank you!


July 16, 2015 9:08 AM

Leave a Comment


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