When: Thursday, July 14th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!
Who:
Andrew Kelly (MVP)
Andrew J. Kelly is the Practice Manager for Performance & Scalability with SolidQ and lives in Plaistow, New Hampshire. He has over 20 years experience with relational databases and application development on both UNIX and Windows platforms but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring, he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001.
Abstract
Understanding Indexes in SQL Server 2008
Understanding the fundamentals of how indexes work and how they are best utilized is an essential part of any DBA or SQL developer's repertoire. Many people assume if you create an index on a column or columns of a table that it will automatically be used when you reference that column. While that may be true under some conditions the actual usage depends on several key factors and they may surprise you. We will cover the fundamentals of how the indexes work under the covers and why you need to know this in order to ensure your indexes are actually helping and not hurting your performance.
Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]
This Months Sponsor:
