Many think of indexing in SQL Server as if it was a mystic art. However, indexing is neither magical nor highly guarded ancient knowledge. This session will show you techniques for determining the best indexing scheme for SQL Server. We will cover indexing for specific queries (query tuning and using query plans), indexing for specific workloads (using Database Engine Tuning Advisor), and indexing with missing index Dynamic Management Views (DMVs).
Robert L. Davis is a Microsoft MVP, SQL Server 2008 Certified Master, an experienced DBA, evangelist, speaker, writer, trainer, and consultant. He is the Principal DBA with Outerwall, Inc. and consults part-time via SQL DBA Master. He has worked with SQL Server for more than 13 years, including recent stints as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software, Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.