Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array

Pinal Dave
SQL
SQL Error Messages, SQL Index, SQL Server, Starting SQL

This was an interesting error which I received while trying to uninstall SQL Server.  In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server.

I must say this was an unfortunate situation where my machine got crashed while SQL Server install was in progress. To get rid of the “incomplete” installation, I decided to remove it and install it again. I went to add/remove program and selected “uninstall” for SQL Server 2017 as I was welcomed by error – Index was outside the bounds of the array. I looked into Summary.txt file and found below.

Read More

SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns

Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Index, SQL Operator, SQL Scripts, SQL Server

I love query tuning and performance tuning projects. In one of the recent Comprehensive Database Performance Health Check my client had a very interesting scenario where their queries were running pretty fast earlier but gradually started to run slow and eventually started to take over 10 minutes to execute. They reached out to me to tune their slow running query. While looking at the query execution plan, there is a big key lookup operation which was actually slowing down their query. I decided to create an index with include column on that table and resolve this issue.

Read More

Does Sort Order in Index Column Matters for Performance? – Interview Question of the Week #199

Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Index, SQL Performance, SQL Server, SQL Statistics

Question: Does Sort Order in Index Column Matters for Performance?

Answer: Wow, it has been a long time since I have heard this question and the matter of fact, I have never blogged about this subject on this blog. I have received this question during my recent Comprehensive Database Performance Health Check.

Read More

SQL SERVER – The Older Way to Find Size of Index Using Deprecated sysindexes

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts, SQL Server, SQL System Table

Earlier this month, I wrote a blog post about How to Find Size of the Index for Tables? – Interview Question of the Week #198, in this I had explained the way to find the size of the index for the table. However, while I was writing the blog post, I was thinking about how I used to love sysindexes once upon a time. However, as now I focus on the new DMVs, I decided not to provide the script of the sysindexes.

Read More