MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005

MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005 (Level 200) (link)

This webcast is really a masterpiece - that's all I can say about it. It really gives you a very good understanding how to diagnose and tune up your applications using SQL to manage their data. I also share the view of the author that there are many software developers that don't have this specific knowledge about writing effective SQL queries, probably because they haven't experienced performance hits. So far, I have projects behind my back where we had to squeeze out every possible second out, because of huge data load and requirement for good performance. I really know what SQL Server Profiler can do, and I really love it!

So this Web cast will give you a really very good idea and real demonstration how you should diagnose and tune your SQL queries so that you have optimal database performance. Highly recommend it!