Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Making the Most of Indexes in Microsoft SQL Server

(this is an on-demand video)

Sponsored by - Quest

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.







More SQL Server Solutions











Learn more about SQL Server tools