For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Making the Most of Indexes in Microsoft SQL Server

Making the Most of Indexes in Microsoft SQL Server
On Demand
  • Recorded Date:Mar. 26, 2019
  • Event:On Demand
Making the Most of Indexes in Microsoft SQL Server

SQL queries aren’t performing well? Already know you’ve got enough hardware to handle the load? Then you’re probably wondering what to check next. One area is the indexing on the data and how those indexes are used. Not having indexes, or having incorrect indexes, forces SQL Server to work harder to return the same data. Or maybe you have the proper indexes, but the queries themselves aren’t making effective use of them. No worries! SQL Server expert Brian Kelley has you covered with everything you need to know about SQL Server indexes.

In this session, you’ll gain a deeper understanding of the SQL Server parse process. You’ll learn how SQL Server parses a query and determines its execution plan for retrieving or updating data. We’ll also review the types of indexes and how SQL Server uses them to increase the efficiency of data access and how poorly written queries can result in not using indexes that would otherwise benefit us. Finally, we’ll talk about how to improve our indexing and queries together for increased SQL Server performance.

Speakers

Brian Kelley - SQL Server Expert

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.