Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?

Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Performance, SQL Training, Workshop

So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capacity. However, yesterday I received a very interesting email which asked me a specific question about the word EVERYONE. Let us read the exact text of the email so you get a clear idea:

Read More

SQL SERVER – How to Drop All the Hypothetical Indexes of Database?

Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Statistics

Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the negative impact of the Database Engine Tuning Advisor (DTA). I was able to help them achieve this by removing the Hypothetical Indexes they had added using the DTA.

Read More

SQL SERVER – Query Listing All the Indexes Key Column with Included Column

Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts, SQL Server

Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, we identified the customers had too many indexes on tables. The goal was to consolidate the indexes and to do the same, we realized that we needed a script which lists all the key columns and included columns of the indexes.

Read More