Welcome to the Orange County SQL Server Professionals User Group
Our Next Meeting: Thursday, October 7, 2010
6:30PM, New Horizons, Anaheim
Topic: Top 10 Query Optimizer Topics for Better Query Performance
Presenter: Benjamin Nevarez
|
|
Presenters' Bio:
Benjamin Nevarez is a database professional with more than 15 years of experience with relational databases and has been working with SQL Server since version 6.5. He has been the technical editor of the two latest Kalen Delaney’s books including “SQL Server 2008 Internals”. Benjamin holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Community Summit. He is currently writing a book about the SQL Server Query Optimizer which will be published this summer. His blog can be found at http://www.benjaminnevarez.com/
Presentation Abstract:
This session will show you how a better understanding on how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the more benefit by focusing both on the concepts and practical solutions. The SQL Server Query Optimizer is a cost-based optimizer which job is to analyze the possible execution plans for a query, estimate the cost of these plans and select the one with the lowest cost. So a better knowledge on how the Query Optimizer works can help both database developers and administrators to get better performance from their databases. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach
|
|