Designing for Performance - General Database Optimizations, Optimizing Procedural Code and Query Optimizations through Indexing

Tech*Ed Pre-Conference Seminar
Written/Presented by Kimberly L. Tripp, SQLskills.com

Performance Tuning spans many areas within SQL Server 2000 from database creation to database design to the code you execute (ad-hoc or procedural). Whether you’re trying to achieve high performance for a few users or scale to support thousands, there are numerous areas that you can tune to improve performance. Attend this pre-conference workshop to perfectly complement your Tech Ed Sessions and immerse yourself into SQL Server Performance Tuning. In this fast-paced, information packed workshop you’ll get a close look at the improvements that will give you the biggest gains. In this seminar we will cover—database structures including optimised file placement and minimizing file/log fragmentation, database design including horizontal and vertical partitioning, writing better search arguments, stored procedure recompilation – when it is preferred and when recompilations are excessive, tips and tricks on how to index for various SARGS as well as joins and much, much more! Through out the day you will hear about performance features and changes coming in SQL Server 2005 - a great way to start your week!

Why you should attend?
This seminar is created from a series of popular shorter sessions and seminars including sessions that have been top rated at conferences around the world – this one day Seminar combines materials to create a cohesive and interesting fully packed one day course designed specifically to complement other Tech*Ed Performance Tuning sessions . Fast-paced and full of detailed technical content, Kimberly’s sessions are always interesting. In 2003 Kimberly was the top rated speaker at the US Microsoft Tech*Ed event where she delivered 5 sessions [out of 380] and all 5 were rated among the top 12 (including the number one spot)! A common comment made regarding Kimberly’s presentations is that she has the gift of being able to communicate technical materials and make subjects that would otherwise be dull – somewhat interesting. Kimberly’s looking forward to this new combination seminar which pulls top sessions, top recommendations and some of the most effective ways to improve performance.

If you want to be able to get better performance and scalability… this is the place to be!