webcast signup header

Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes


Few things influence the speed and performance of SQL statements within SQL Server® as much as indexes. This session will help you understand the basics of query performance in relation to the indexes on your production database. We'll teach you how to determine whether you're using good index strategies and the direct impact your indexing strategy has on queries.

Using a variety of examples, we'll show you how indexes can affect query performance, and a variety of best practices and ways queries can be written to maximize indexes in place. In this session, you'll learn things like:

  1. The building blocks of index behavior, such as cardinality estimates, density, and statistical distribution
  2. How to determine which indexes are used by a query by reviewing its execution plan and by querying important Dynamic Management Views (DMVs)
  3. A variety of query patterns and best practices to ensure optimal index usage

Prerequisites: Beginning SQL query writing skills. Basic understanding of indexes in a relational database.



Webcast Date

Tuesday, April 27, 2021
1:00:00 PM EDT (New York) | 5:00:00 PM UTC

Speaker(s)

presenter 1

Kevin Kline

Kline is a noted database expert and software industry veteran. At previous companies, his product designs won multiple "Best of" and "Readers' Choice" awards.

Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and ten other books. He is a frequent webinar host and speaker at various industry conferences and user groups and has traveled the world as part of his multi-continent roadshows.

A Microsoft SQL Server MVP since 2003, Kline is passionate about improving the quality of life for Microsoft database professionals and their customers. As a SolarWinds Head Geek, he focuses on helping customers with troubleshooting and adopting best practices for optimal database performance monitoring, on-premises and in the cloud.


presenter 2

Thomas LaRock

Thomas LaRock has over 20 years of IT experience holding roles such as programmer, developer, analyst, and database administrator. He is a Microsoft Certified Master, VMware vExpert, Microsoft Certified Trainer, and a 12-time Microsoft Data Platform MVP.

Thomas has spent much of his career focused on data and database administration, which led to his election as a Technical Evangelist for Confio Software in 2010, where his research and experience helped create the initial versions of the software now known as SolarWinds® Database Performance Analyzer (DPA).

LaRock has served on the board of directors for the Professional Association for SQL Server (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He’s made it his mission to give IT and data professionals longer weekends.


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:

 
Development Best Practices for SQL Server
Tuesday, April 13, 2021 - 3:00:00 PM EST
Speaker(s): Andy Warren - Sponsor: MSSQLTips

 
Keeping Your SQL Servers Running Strong
Thursday, April 15, 2021 - 1:00:00 PM EST
Speaker(s): Joey DAntoni - Sponsor: dbWatch

 
Moving SQL Server workload to the cloud
Thursday, April 22, 2021 - 1:00:00 PM EST
Speaker(s): Anat Dror - Sponsor: Quest

 
SQL Server Architecture Options for Disaster Recovery and High Availability
Thursday, April 29, 2021 - 1:00:00 PM EST
Speaker(s): Mike Walsh and Dave Bermingham - Sponsor: SIOS

 
Smashing SQL Server Silos with DreamFactory
Tuesday, May 04, 2021 - 1:00:00 PM EST
Speaker(s): Jason Gilmore - Sponsor: DreamFactory

 
Identify SQL Server Performance Problems Quickly and Efficiently
Thursday, May 06, 2021 - 1:00:00 PM EST
Speaker(s): Franklin Yamamoto - Sponsor: SQLGrease

 
Database Farm Management Solution from dbWatch
Thursday, May 13, 2021 - 1:00:00 PM EST
Speaker(s): Per Christopher Undheim - Sponsor: dbWatch

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-2021 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.