Getting the best of SQL: Understanding Query Optimization Statistics
If you have ever wondered why the query optimizer does what it does, this session will help you understand most important input the optimizer uses to use an index or not. We will review what SQL Statistics are, when are they build, how are they maintained and finally how to troubleshoot and optimize SQL performance using statistics.
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Javier Loria is a Solid Quality Mentors Mentor based in Costa Rica. He began his professional career in 1992, as a software developer and system engineer. His career evolved rapidly to the training side, especially in the XML and OLAP world, training customers at different locations in Latin America. He is a software architect, and Business Intelligence Architect assisting our customers in Latin America. Javier became SQL Server MVP in 2001. Javier is an MCT, MCSE, MCSD, MCDBA, and MCAD. Javier was an active member responsible for writing the Microsoft SQL Server 2005 courseware. He is the coauthor of several books including MOC2782: Designing Microsoft® SQL Server™ 2005 Databases, MCTS Training Kit 70-431: Implementing and Maintaining SQL Server 2005 and Microsoft SQL Server 2005 Database Essentials Step by Step.
- Video
The video is not available to view online.
- Session Files Explorer