Making the Most of Indexes in Microsoft SQL Server
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.
Tuesday, March 26, 2019
5:00:00 PM UTC | 1:00:00 PM EDT
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.
Register for this webinar:
Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.