December 11, 2008 Meeting
Fundamentals of Query Optimization & Performance Tuning
Presentation Abstract:
We will begin with examining the fundamentals of key concepts in SQL Server Performance Tuning such as Indexing, Statistics, Primary and Foreign Keys, and Referential Integrity, and finish off with live examples of how we can improve performance of our queries, and make our customers happy. We will examine the power of reading and understanding execution plans, and will learn how to use SQL Server 2005 Database Tuning Advisor to quickly optimize your queries and stored rocedures.
Presenter Bio:
Allen Berezovsky is a senior DBA and developer with HarborObjects with over 12 years of experience. He is Microsoft certified and has a keen eye for solving real life SQL Server problems. His experience in implementing large scale web applications has helped him gain in depth knowledge about performance tuning and optimization of SQL Server.