If we are talking about searching for tables specifically here then you could use these:

The first one, usp_findColumn_thisDB, takes a parameter and searches all tables with a column matching that...

With a couple very rare exceptions (not relevant for this conversation) I have never had any issues with disabling indexes.

Based on what you've said I cannot see any use for them but I would I would disable them first for a little while to be on the safe side...

Determining the performance impact of removing these unused indexes is important; understanding the impact of leaving them there is also important. In the past 14 years I cannot recall a...

I started with the first few:

Create Sample Data:

CREATE table x(Value varchar(20))

INSERT INTO x VALUES

('a'),

('A'),

('NULL'),

('NULL xxx'),

('113Y'),

('111Y'),

('1')

-- 1. string starts with 3 digit same number Example 111Y,333Y, 555 H etc

-- a....

This is a very interesting quandary indeed. I am sure this can be done using a little less code but here is what I came up with:

SET NOCOUNT ON

GO

/***********************************************************************

1) Create...