Joe Webb Blog

Musing and observations about SQL Server, other technogies, and sometimes just life in general

SQLTeach - Writing better queries presentation

Here's a presentation that I gave yesterday afternoon at DevTeach/SQLTeach. It's called Tips & Tricks for Writing Better Queries. It's very similar to the presentation I gave a month or so ago at the Nashville SQL Server User Group meeting.

To everyone who attended the session - thanks for spending a part of your day with me. I hope it was worth your while. Please feel free to email me if you have any additional questions or comments. And please remember to login to your SQLTeach account and submit your session evals.

Cheers!

Joe
kick it on DotNetKicks.com

Legacy Comments


GregD
2008-05-15
re: SQLTeach - Writing better queries presentation
The links do not work - javascript: void(0);/*###*/

Luciano Evaristo Guerche
2008-05-15
re: SQLTeach - Writing better queries presentation
javascript:void(0);/*1210861996453*/, javascript:void(0);/*1210862028980*/ and javascript:void(0);/*1210862076845*/? How do I proceed to to reach the presentation?

Joe Webb
2008-05-15
re: SQLTeach - Writing better queries presentation
Oops! I'm not sure how that happened. I should have doubled checked the links after posting.

I've updated the post to fix the problem.

Thanks for letting me know.

Joe

Zack Jones
2008-05-16
re: SQLTeach - Writing better queries presentation
So that's why execution plans made little sense to me I was reading them left to right instead of right to left. Thanks for clarifiy that!

I found your "Avoid Select * " statement somewhat ironic since the "Understanding Executation Plans" shows Select * :)

lorne schachter
2008-05-18
re: SQLTeach - Writing better queries presentation
Can you save the presentation in other than Office 2007?

Joe Webb
2008-05-19
re: SQLTeach - Writing better queries presentation
I've got the presentation in a VPC. I'll convert it the next time I boot it up. In the meantime, here's a link to a pptx viewer that will allow you to view the presentation. You'll probably need the viewer at some point in the future anyway.

http://www.microsoft.com/downloads/details.aspx?familyid=048dc840-14e1-467d-8dca-19d2a8fd7485&displaylang=en

Cheers!

Joe

SEO
2008-05-21
re: SQLTeach - Writing better queries presentation
thanks for all...