When: Thursday, 12 February 2009, 18:00-20:30 Venue: I.T. Intellect, Shop 405b Level 3, Musgrave Centre, 115 Musgrave Road, Musgrave Presenter: Gail Shaw, SQL MVP Topic: The dirty dozen... 12 Ways to write badly performing T-SQL RSVP: Please RSVP by replying to this thread.
SA Developer.Net KZN is proud to present Gail Shaw, SQL MVP who has kindly offered her time to present her talk from the PASS Summit last year.
Database performance is a hot topic and there are often questions asked pertaining to the best way to write T-SQL queries. In this presentation, the attendee will NOT be shown the best manner in which to write queries but rather numerous ways of how to write poorly performing queries, with the hope that the attendee will obtain an understanding of what NOT to do. The user will be guided through each query, be shown why it's not the optimal way of doing things and then shown a well-written query that achieves the same results.
Gail's Bio: Gail is a database consultant from Johannesburg, specialising in performance tuning and database optimisation. Before moving to consulting she worked at a large South African investment bank and was responsible for the performance of the major systems there. Gail was awarded MVP for SQL Server in July 2008 and spoke at both TechEd South Africa and the PASS Community Summit in Seattle last year.
The views, comments and opinions expressed in this post is that of the poster alone unless otherwise indicated.
Diago.co.za
I'll definately be there, but let's see what Google turns up on "T-SQL"
Orikuuido:I'll definately be there, but let's see what Google turns up on "T-SQL"
Gail Shaw - SQL In the WildSQL Server MVP-- Chaos, panic and disorder. My job here is done!
HI Gail,
well I understand SQL in general, but have never worked with T-SQL or MS SQL Server, but I am sure I'll catch on eventually. Let me see what I can learn about it on Google and I'll play around with it a bit, but I'll be there nonetheless. I still have to teach my girlfriend about SQL before then, so it'll be a nice learning curve for the both of us
I would like to RSVP for talk on badly performing T-SQL.
Regards,
Christof
Orikuuido:I am sure I'll catch on eventually.
Oh I'm sure you will.
Just note the issues and alternatives that I'm going to be covering are specific to SQL Server, and won't be directly applicable to MySQL, Oracle or other database engines. Different optimisers, different query processors, different execution characteristics.
Hi, I will be attending.
Donovan
Damn...it's my girfriends birthday on the 12th....
...oh well; I hope she enjoys supper at IT Intellect
A Program is only complete when the Programmer Dies