Advanced Physical Database Design for SQL Server 2008
In this session we will cover advanced aspects of physical database design such as choice of clustered vs. non-clustered indexes, use of normalization to improve performance, partitioning as a form of indexing, things to consider when working with sparse columns, filtered indexes, indexed views, and partition-aligned indexed views. We will illustrate some of the advanced functionality available in SQL Server 2008 such as missing index DMVs and Database Tuning Advisor (DTA).
Victor Isakov is visiting from Australia, 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 has 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 SQLServer 2005 and 2008 Certification exams and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. www.victorisakov.com