Abstract: One of the most important routes to high performance in a SQL Server database is the index. Indexes speed up the querying process by providing swift access to rows in the data tables, In this highly popular session targeted towards the .NET developers, we will go over the how indexes work, and how to create them for maximum benefit. We will also go over some of the tips and tricks that DBAs use to improve index performance.

Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny uses these skills on a regular basis in his current role as a Sr. Database Administrator and Architect at Awareness Technologies. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP. Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.