Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and Implementing SQL Server Database Indexes, you'll gain knowledge on how to avoid these issues through the effective use of SQL Server database indexes. First, you'll discover the main index types that SQL Server has. Next, you'll explore considerations for their use. Finally, you'll learn how to choose indexes and index keys to best support your applications. When you've finished this course, you'll be in a good position to optimize all of your SQL Server databases and improve your applications' speed and throughput.
Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.
Course Overview Hi everyone. My name's Gail Shaw. Welcome to my course on Designing and Implementing SQL Server Database Indexes. I'm a technical lead in the data solutions division at Intellect Software based in Johannesburg, South Africa. Good indexing is critical for well- performing databases, but very few databases that I see in production have anything resembling good indexing. Learning how to create indexes to support your database workload will allow you to ensure that your applications are performing to their peak. In this course, we're going to have a look at several types of indexes that SQL Server has. We're going to look at how to choose a clustered index and what the tradeoffs are for various choices there. We'll look at nonclustered indexes, indexes which you create to support your workload. We'll look at indexed views and see where they're useful. And we'll look at columnstore indexes, how they differ from traditional indexes, and where they excel. By the end of this course, you'll be able to create effective indexes for almost any SQL Server workload. This is an introductory course, so no prior experience in indexing is required, but you should be familiar with SQL Server table design and basic queries. Familiarity with execution plans is a bonus. I hope you'll join me on this journey to learn all about indexing with the Designing and Implementing SQL Server Database Indexes course, at Pluralsight.