Question about inclusive language update for sp_BlitzIndex

[VladDBA]

Is there any more work needed on the inclusive language update for sp_BlitzIndex? If yes, is there something I can help with? I already have a list of "sanitized" finding names that covers the most common findings as part of a helper tool I've made for PSBlitz's HTML output.

[BrentOzar]

Howdy! I actually closed that issue because I don't have the time to work on it. If you want to tackle it, can you put the list of before & after names here for discussion? After we've gotten consensus from the community, you can knock it out if you want.

[VladDBA]

Hey, Brent! Sure, here's what I have so far:	Priority	FindingsGroup	Finding	UpdatedFindingsGroup	UpdatedFinding
10	Index Hoarder	Many NC Indexes on a Single Table	Overindexing	Many NC Indexes on a Single Table
10	Index Hoarder	Unused NC Index with High Writes	Overindexing	Unused NC Index with High Writes
20	Multiple Index Personalities	Duplicate Keys	Redundant Indexes	Duplicate Keys
30	Multiple Index Personalities	Borderline Duplicate Keys	Redundant Indexes	Approximate Duplicate Keys
40	Indexaphobia	High Value Missing Index	Index Suggestion (could also be Underindexing)	High Value Missing Index
70	Aggressive Indexes	Total Lock Time with Long Average Waits	Prone to Locking	Total Lock Time with Long Average Waits
70	Aggressive Indexes	Total Lock Time with Short Average Waits	Prone to Locking	Total Lock Time with Short Average Waits
80	Abnormal Psychology	Columnstore Indexes with Trace Flag 834	Abnormal Design Pattern	Columnstore Indexes with Trace Flag 834
80	Abnormal Psychology	Identity Column Near End of Range	Abnormal Design Pattern	Identity Column Near End of Range
80	Abnormal Psychology	Filter Columns Not In Index Definition	Abnormal Design Pattern	Filter Columns Not In Index Definition
90	Functioning Statistaholics	Low Sampling Rates	Statistics Warnings	Low Sampling Rates
90	Functioning Statistaholics	Statistics Not Updated Recently	Statistics Warnings	Statistics Not Updated Recently
90	Functioning Statistaholics	Statistics with NO RECOMPUTE	Statistics Warnings	Statistics with NO RECOMPUTE
100	Index Hoarder	NC index with High Writes:Reads	Overindexing	NC index with High Writes:Reads
100	Self Loathing Indexes	Heap with a Nonclustered Primary Key	Indexes Worth Reviewing	Heap with a Nonclustered Primary Key
100	Self Loathing Indexes	Heap with Forwarded Fetches	Indexes Worth Reviewing	Heap with Forwarded Fetches
100	Self Loathing Indexes	Large Active Heap	Indexes Worth Reviewing	Large Active Heap
100	Self Loathing Indexes	Low Fill Factor on Clustered Index	Indexes Worth Reviewing	Low Fill Factor on Clustered Index
100	Self Loathing Indexes	Low Fill Factor on Nonclustered Index	Indexes Worth Reviewing	Low Fill Factor on Nonclustered Index
100	Self Loathing Indexes	Medium Active Heap	Indexes Worth Reviewing	Medium Active Heap
100	Self Loathing Indexes	Small Active Heap	Indexes Worth Reviewing	Small Active Heap
100	Serial Forcer	Computed Column with Scalar UDF	Forced Serialization	Computed Column with Scalar UDF
100	Serial Forcer	Check Constraint with Scalar UDF	Forced Serialization	Check Constraint with Scalar UDF
150	Abnormal Psychology	Cascading Updates or Deletes	Abnormal Design Pattern	Cascading Updates or Deletes
150	Abnormal Psychology	Unindexed Foreign Keys	Abnormal Design Pattern	Unindexed Foreign Keys
150	Abnormal Psychology	Columnstore Index	Abnormal Design Pattern	Columnstore Index
150	Abnormal Psychology	Column Collation Does Not Match Database Collation	Abnormal Design Pattern	Column Collation Does Not Match Database Collation
150	Abnormal Psychology	Compressed Index	Abnormal Design Pattern	Compressed Index
150	Abnormal Psychology	In-Memory OLTP	Abnormal Design Pattern	In-Memory OLTP
150	Abnormal Psychology	Non-Aligned Index on a Partitioned Table	Abnormal Design Pattern	Non-Aligned Index on a Partitioned Table
150	Abnormal Psychology	Partitioned Index	Abnormal Design Pattern	Partitioned Index
150	Abnormal Psychology	Spatial Index	Abnormal Design Pattern	Spatial Index
150	Abnormal Psychology	XML Index	Abnormal Design Pattern	XML Index
150	Index Hoarder	Borderline: Wide Indexes (7 or More Columns)	Overindexing	Borderline: Wide Indexes (7 or More Columns)
150	Index Hoarder	More Than 5 Percent NC Indexes Are Unused	Overindexing	More Than 5 Percent NC Indexes Are Unused
150	Index Hoarder	Non-Unique Clustered Index	Overindexing	Non-Unique Clustered Index
150	Index Hoarder	Unused NC Index with Low Writes	Overindexing	Unused NC Index with Low Writes
150	Index Hoarder	Wide Clustered Index (>3 columns or >16 bytes)	Overindexing	Wide Clustered Index (>3 columns or >16 bytes)
150	Self Loathing Indexes	Disabled Index	Indexes Worth Reviewing	Disabled Index
150	Self Loathing Indexes	Hypothetical Index	Indexes Worth Reviewing	Hypothetical Index
200	Abnormal Psychology	Identity Column Using a Negative Seed or Increment Other Than 1	Abnormal Design Pattern	Identity Column Using a Negative Seed or Increment Other Than 1
200	Abnormal Psychology	Recently Created Tables/Indexes (1 week)	Abnormal Design Pattern	Recently Created Tables/Indexes (1 week)
200	Abnormal Psychology	Recently Modified Tables/Indexes (2 days)	Abnormal Design Pattern	Recently Modified Tables/Indexes (2 days)
200	Abnormal Psychology	Replicated Columns	Abnormal Design Pattern	Replicated Columns
200	Abnormal Psychology	Temporal Tables	Abnormal Design Pattern	Temporal Tables
200	Cold Calculators	Definition Defeatists
200	Functioning Statistaholics	Filter Fixation	Statistics Warnings	Filter Fixation
200	Index Hoarder	Addicted to Nulls	Overindexing	High Ratio of Nulls
200	Index Hoarder	Addicted to Strings	Overindexing	High Ratio of Strings
200	Index Hoarder	Wide Tables: 35+ cols or > 2000 non-LOB bytes	Overindexing	Wide Tables: 35+ cols or > 2000 non-LOB bytes
200	Self Loathing Indexes	Heaps with Deletes	Indexes Worth Reviewing	Heaps with Deletes
200	Workaholics	Scan-a-lots (index-usage-stats)	High Workloads	Scan-a-lots (index-usage-stats)
200	Workaholics	Top Recent Accesses (index-op-stats)	High Workloads	Top Recent Accesses (index-op-stats)
250	Feature-Phobic Indexes	Few Indexes Use Includes	Omitted Index Features	Few Indexes Use Includes
250	Feature-Phobic Indexes	No Filtered Indexes or Indexed Views	Omitted Index Features	No Filtered Indexes or Indexed Views
250	Feature-Phobic Indexes	No Indexes Use Includes	Omitted Index Features	No Indexes Use Includes
250	Feature-Phobic Indexes	Potential Filtered Index (Based on Column Name)	Omitted Index Features	Potential Filtered Index (Based on Column Name)
250	Medicated Indexes	Optimized For Sequential Keys	Specialized Indexes	Optimized For Sequential Keys