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 is a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software. Previously, he was the Program Manager for the SQL Server Certified Master Program in Microsoft Learning. He was also a Sr. Production DBA at Microsoft with more than 12 years’ experience with SQL Server -- author of Pro SQL Server 2008 Mirroring -- writer for SQL Server Magazine -- Microsoft Certified Master: SQL Server 2008 -- Speaker/trainer.