Para tener la mejor experiencia web, use IE11+, Chrome, Firefox o Safari.

Making the Most of Indexes in Microsoft SQL Server

Making the Most of Indexes in Microsoft SQL Server
A pedido
  • Fecha de grabación:Mar. 26, 2019
  • Evento:A pedido
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.

Oradores

Brian Kelley - SQL Server Expert

Vea su transmisión vía Internet

Espere...

triangle-down check
Al realizar la descarga, se registra para recibir un correo electrónico de marketing de parte nuestra. Puede optar por no recibir ningún correo electrónico siguiendo las pasos que se detallan en nuestra Política de privacidad.

reCAPTCHA protege este sitio. Consulte la Política de privacidad de Google y los Términos de uso.