Indexing for Performance in SQL Server 2000/2005/2008
Kimberly L. Tripp and Paul S. Randal
8th - 9th September 2008
There are many areas of performance tuning in SQL Server: database design, application design, hardware/software configuration, and many more. But none are as important as indexing. Creating the "right indexes" is the most important thing you can do for performance and scalability. Is proper indexing something your application is missing? Do you realize the impact of your clustering key; forcing your base structure of your tables to be either ordered or unordered. If ordered is chosen, by what type of column(s) should the data be ordered? Is the decision solely based on query performance or are there other factors?
Whether your system is 24x7 or a small system just trying to setup for future growth and improved performance this course is for you! We will cover the often-overlooked impacts of poorly chosen clustered indexes, where/why clustered indexes help the most and how the type of table and the type/frequency of your queries affect your decisions. Additionally, once the internals, statistics and base table structures have been defined, we will talk about indexing strategies for search arguments (including SQL Server 2008 Filtered Indexes), joins, aggregations and appropriate uses for indexed views. Finally, we'll discuss index maintenance as well as how to evaluate your indexing strategy over time to make sure it remains appropriate as your data and workload changes.
If you want better performance and excellent insight into the wide range of indexing strategies - as well as how things work internally, this is the place to be!
Course Modules
- Index Internals
- Statistics
- Indexing Strategies, Part I: SARGs and Joins
- Indexing Strategies, Part II: Aggregations and Indexed Views
- Index Maintenance
- Is Your Indexing Strategy Working?
Course Length/Type
Two day instructor led seminar.
Kimberly L. Tripp
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Her career with database technologies began with IBM in 1988 and with Microsoft SQL Server in 1990. Kimberly has presented lectures and seminars at Microsoft Tech*Ed and other top-flight SQL Server-related events since 1996 and is consistently top-rated both on quality of technical content and presentation style. Kimberly regularly consults with customers to help them tackle their availability and performance issues as well as works with Microsoft to provide new and interesting technical resources.
Paul S. Randal
Paul S. Randal is the Managing Director of SQLskills.com which he runs with his wife Kimberly L. Tripp. He is a SQL Server MVP and writer for TechNet Magazine. He worked on the SQL Server Storage Engine team at Microsoft from 1999 to 2007. Paul wrote DBCC CHECKDB/repair for SQL Server 2005 and was responsible for the Core Storage Engine during SQL Server 2008 development. Paul is an expert on disaster recovery, high-availability, and database maintenance and is a regular, top-rated presenter at conferences around the world. He blogs at SQLskills.com/blogs/paul.