Queries Using Specific Index – SQL in Sixty Seconds #180

2 years ago

During Comprehensive Database Performance Health Check we often discuss dropping indexes that are not helpful and systematically and scientifically we drop them. However, the biggest challenge I face during the conversation is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index in today’s quick SQL in Sixty Seconds video.

If you are looking for the script used in this video, the link is SQL SERVER – Finding Queries Using Particular Index. Here is the video:

If you liked this blog, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL DMV, SQL in Sixty Seconds, SQL Index, SQL Server

Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179

Tuning Query Cost 100% – SQL in Sixty Seconds #181

SQL SERVER – Discovery Report – How to Find Information About Installed Features?

December 15, 2016

SQL SERVER – Types of Triggers

August 30, 2021

SQL SERVER – Msg 3035, Level 16 – Cannot Perform a Differential Backup for Database “SQLAuthority”, Because a Current Database Backup Does not Exist

April 19, 2017

Leave a Reply Cancel reply

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 13 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Exclusive Newsletter

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials