PASS Community Summit 2009: Pre-Conference Sessions (Enterprise Database Administration and Deployment)
Return to Session Listings
SQL Server 2005/2008: Indexing for Performance
Kimberly Tripp (SQLskills.com)
Paul Randal (SQLskills.com)
Indexing is by far the most important aspect to database performance and health. But, do you have the right indexes? Do you have too few, or too many? And, are the indexes the RIGHT indexes? In this workshop we''ll cover what makes an index useful and how to create the RIGHT indexes for a variety of different problem scenarios. In addition to looking at which indexes work for what types of queries, we''ll round out the day looking at the DMVs that can help us create some of the missing indexes and drop the unused. Primary topics covered: index internals, indexing strategies, statistics and how to tell if your strategies are working! If you want better performance, as well as a more manageable database, this is the place to be - even if you cannot change your schema! (NOTE: The "SQL Server Covering: Concepts, Concerns, & Costs" session during the conference has a small amount of overlap with this workshop but the point of the workshop will be to dive into more of the internals and details of why these decisions are so critical. We will not rediscuss the specific strategies used in the session.) Topics covered: Index Internals Data Access Patterns Statistics Indexing Strategies How to know if your indexing strategies are working?
About the Speakers
Paul S. Randal is the Managing Director of SQLskills.com, which he runs with his wife Kimberly L. Tripp. Paul is a SQL Server MVP, Microsoft Regional Director and Contributing Editor for TechNet Magazine. He holds a patent (with Microsoft) on consistency checking technology.
Paul started in the industry in 1994 working for DEC on the VMS file system and its check/repair tools (the equivalent of chkdsk for NTFS.
In 1999 he moved to Microsoft to work on SQL Server, specifically on DBCC. For SQL Server 2000, he concentrated on index fragmentation - well, removing it! - writing both DBCC INDEXDEFRAG and DBCC SHOWCONTIG, plus various algorithms in DBCC CHECKDB to support it being able to run online.
Paul then spent the first 3 years of SQL Server 2005 development rewriting the DBCC CHECKDB and repair code-base, gaining extensive insight into disaster recovery scenarios and problems through close partnership with the SQL Server PSS (Product Support) group. Paul spent the remaining two years of SQL Server 2005 development leading/managing a 9-person development team in the Core Storage Engine. His team was responsible for data access and storage (DBCC, space allocation, indexes & heaps, pages & records, text/LOB storage, snapshot isolation, bulk load etc).
For SQL Server 2008, Paul decided to put his customer passion to better use and switch to a Program Management role within the Storage Engine team - first with responsibility for the entire Storage Engine for a year, and then with a narrower, more hands-on focus on the Core Storage Engine. This involved both feature set definition plus customer and partner engagements. It was during this phase of Paul's career that he first started public speaking, with his first session being on DBCC Internals at TechEd US 2006. This was also where he met Kimberly, and they were subsequently married July 29th 2007.
In 2007, after almost 9 years on the SQL Server team, Paul left Microsoft to join Kimberly running SQLskills.com and pursuing his new-found passion for writing, teaching, and consulting. Paul is a regular, top-rated presenter at conferences and user groups around the world on high-availability, disaster recovery, database maintenance, and Storage Engine internals. Paul also teaches classes on Database Maintenance and High-Availability at Microsoft, and is a course author/instructor for the Microsoft Certified Architect - Database qualification. His popular blog is at http://www.sqlskills.com/blogs/paul/.
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. Since 1995, Kimberly has worked as a speaker, writer, trainer and consultant for her own company SYSolutions, Inc. (http://www.SQLskills.com). In consulting, Kimberly tackles tough real-world problems focused mostly on performance, tuning, system availability, and minimizing data loss. In writing, Kimberly writes for SQL Server Magazine, has written numerous whitepapers and recently co-authored the SQL Server 2008 Internals title. In speaking, Kimberly lectures for a variety of events such as Microsoft Tech*Ed, SQL PASS, and SQL Connections where she is consistently a top rated speaker. Her comments usually include that she has a gift of being able to discuss complex technical topics with ease and occasional humor. In addition to speaking at the conference, Kimberly co-chairs the SQL Connections conference with her husband, Paul S. Randal. Currently, Kimberly is creating SQL Server 2008 content including articles, labs, whitepapers, and workshops. Prior to starting SYSolutions, Kimberly held positions at Microsoft including Subject Matter Expert/Trainer for Microsoft University and Technical Writer for the SQL Server Development Team. You can get more details about Kimberly online at www.SQLskills.com and on her blog: www.SQLskills.com/blogs/Kimberly.
See the other sessions Paul and Kimberly are presenting at PASS Community Summit 2009 here.
Register Now for PASS Summit 2009!