25/05/2011 6:16:05 AM
Does SQL Server's Query Optimizer seem inconsistent at times? Executing complex queries very quickly at times, yet sometimes executing simple queries frustratingly very s-l-o-w-l-y? What are your options when the Query Optimizer isn't "doing it's job"? One potential solution is the use of query hints.
In this session Victor Isakov (MCA, MCM, MCT, MVP) will examine the most-commonly used queries hints. More importantly he will discuss the use cases where you should use query hints, as opposed to trying alternative solutions first.
Along the way we will discuss the importance of statistics, plan guides and other various aspects of query tuning.
Speaker: Victor Isakov (SQL Server Solutions)
Victor Isakov is a Database Architect and Microsoft Certified Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. He is one of the first IT professionals to get the Microsoft Certified Master and Microsoft Certified Achitect certifications globally.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, 1 June 2011