27/01/2009 6:53:25 PM
With the release of SQL Server 2008 the database developer has more choices in their arsenal for optimally indexing database solutions. In this session we will explore the different indexing technologies that are available in SQL Server 2005 and SQL Server 2008, such as included, composite and filtered indexes. We will discuss the primary design considerations and tradeoffs made when implementing an indexing strategy and present more "exotic" scenarios such as how to implement custom hash indexes, how to combine filtered indexes with sparse columns, partitioned indexes and how to implement partitioned views with different underlying table indexes.
Speaker: 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 2005 Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning.
*** IMPORTANT ***
Due to the interest shown in these events, the limited seating capacity and the registration process we would like everyone to confirm their attendance. We need people to RSVP 72 hours before the event so as to be able to print out the name badges and ensure a smooth registration process.
Venue: Westpac Place • 275 Kent St • Sydney • NSW 2000 |
Duration 12:30 - 14:30 |
On: Wednesday, 4 March 2009