August Meeting - Understanding Indexes in SQL Server 2008
Wednesday, August 31, 2011 from 5:30 PM to 7:45 PM (EDT)
This month we are pleased to welcome back to Charlotte renowned speaker and SQL Server performance expert - Andrew J. Kelly.
Understanding Indexes in SQL Server 2008 by Andrew J. Kelly, SQL Server MVP
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.
Andrew J. Kelly is the Practice Manager for Performance & Scalability with SolidQ and lives in Mrytle Beach, South Carolina. 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.Read his popular blog: http://sqlblog.com/blogs/andrew_kelly/default.aspx
5:30 PM Networking and Pizza
6:00 PM Stump the SQL Experts - open Q&A Forum with CSSUG Members
6:15 PM Main Presentation
7:30 PM Meeting End
7:45 PM Post-Meeting Social Hour - Join Us for Drinks at a venue TBA
The meeting is being held at the Microsoft Offices in AP1 Those conference rooms are located at the far end of the building.
TEKsystems® has been a loyal sponsor of the Charlotte SQL Server Users Group. TEKsystems® provides technology staffing and services, helping businesses deploy high-caliber IT and communications expertise. With roots as the nation’s largest IT staffing firm, they’ve become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Visit www.teksystems.com for more info.
SQL Sentry, Inc., is a Charlotte based company and a long time sponsor of the Charlotte SQL Server Users Group. SQL Sentry creates software products to optimize the performance of Microsoft® SQL Server® environments. SQL Sentry software provides unprecedented visibility and control that enables database administrators to monitor their database environment with confidence, and quickly diagnose and solve complex performance problems as they arise. Visit www.sqlsentry.net for more info.
About Our Group:
Charlotte, NC has a dynamic, growing business environment filled with opportunities for SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of that environment by providing a venue for user education and peer collaboration. Our group is a certified Chapter of PASS and we recommend all members join that organization.
When & Where
Charlotte SQL Server Users Group
Charlotte, NC has a dynamic, growing business environment filled with opportunities for SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of our regional community by providing a venue for user education, peer collaboration and csareer networking. www.Charlotte-SQL.org