Making the Most of Indexes in Microsoft SQL Server

Quest sponsored on-demand webinar

Webcast Abstract

Your SQL Server database queries aren’t performing well and you know you have enough hardware to handle the load. What else should you look at? One area is the indexing on the data and how those indexes are used. Not having indexes, or not having the correct indexes, means SQL Server has to do more work to return the same data. Likewise, you can have the proper indexes, but the queries themselves don’t make effective use of them.

In this presentation, we’ll take a look at 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 be more efficient with 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 performance.

Speaker - K. Brian Kelley

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

get free sql tips
agree to terms