29/02/2012 6:56:42 AM
Columnstore indexes represent a completely new type of index in SQL Server 2012. Columnstore indexes and the new vector-based "batch mode" of query execution can provide query improvements of 100x (or more in certain cases).
In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the basics of columnstore indexes, including their internals, how query execution is enhanced by them, and what scenarios they support.
As with any new feature, there are some areas where performance may not improve as much as expected. Victor will cover these use cases and how to tune your application to work around them.
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, 4 July 2012