24/02/2010 12:21:59 AM
There are a number of core patterns and best practices that developers can use within SQL Server 2008 to ensure optimal performance. In this session Victor will go through these patterns and best practices, including logical and physical database design, statistics management, query design, query tuning, problems areas to avoid, and more. He will cover which query constructs cause the query optimizer to rely on guesses rather than accurate statistical estimates for the number of rows returned by sub-plan. How parameters and local variables effect plan selection and optimality, and how that can impact performance of your applications. He will also cover how your choice of data types for join keys can affect join performance, and how data compression affects CPU overhead and I/O.
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 • 280 Pitt Street • Sydney • NSW • 2000 |
Duration 12:00 - 14:00 |
On: Wednesday, 3 March 2010