Para obter uma melhor experiência web, utilize o IE11+, Chrome, Firefox ou Safari.

Making the Most of Indexes in Microsoft SQL Server

Making the Most of Indexes in Microsoft SQL Server
Sob demanda
  • Data gravada:Mar. 26, 2019
  • Evento:Sob demanda
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.

Palestrantes

Brian Kelley - SQL Server Expert

Assistir a seu webcast gratuito

Por favor, aguarde...

triangle-down check
Ao fazer o download, você se inscreverá para receber nosso e-mail marketing. Para cancelar sua inscrição, siga as etapas descritas em nossa Política de Privacidade.

reCAPTCHA protege este site. Confira a Política de Privacidade e os Termos de Uso do Google.