The presentation will focus on the steps to tune queries in SQL Server 2005/2008. Some of the topics that will be covered are: • Steps to determining when a query should be tuned. • How to read query plans. • System tables that will help you determine what sql is performing poorly. • Overview of set statements that will help you troubleshoot queries. • Effect of poor performing update or delete queries on overall system performance. • Steps for writing better performing queries. In addition the presentation will cover how to use query hints and when it is appropriate to use them.

Presented by Chris Barth

Mr. Barth possesses over fifteen years of professional experience in application architecture, design, development, and support. His specialties include designing, architecting and tuning DBMS environments, such as very large SQL Server solutions as well as Oracle and PostgreSQL solutions. He has also designed and developed business solutions for the retail, banking, health care and legal industries. Some of his recent experience involves developing a Bankruptcy detection system and a Balance Transfer Credit Card system for a large debt buyer. These projects involved the design and development of Federated databases utilizing T-SQL, XML and the CLR.