webcast signup header

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.

Webcast Date

Tuesday, March 26, 2019
5:00:00 PM UTC | 1:00:00 PM EDT

Speaker(s)

presenter 1
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.

Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
Eating the Elephant: Cloud Database Migration Considerations
Thursday, March 28, 2019 - 11:00:00 AM EDT
Speaker(s): Douglas McDowell and Devon Leann Wilson - Sponsor: SentryOne

 
SQL Server Performance and Scalability
Thursday, April 11, 2019 - 3:00:00 PM EDT
Speaker(s): Jeremy Lowell - Sponsor: IDERA

 
Introduction to SQL Server Query Store
Tuesday, April 16, 2019 - 1:00:00 PM EDT
Speaker(s): Andy Warren - Sponsor: Quest

Signup for our newsletter

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.


 

 


Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.