Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sp_BlitzIndex: remove psychological terms #3250

Open
BrentOzar opened this issue Apr 16, 2023 · 1 comment
Open

sp_BlitzIndex: remove psychological terms #3250

BrentOzar opened this issue Apr 16, 2023 · 1 comment
Assignees

Comments

@BrentOzar
Copy link
Member

When we first wrote sp_BlitzIndex, we used psychological terms to describe indexes.

Wording like "Self Loathing", "Abnormal Psychology", and "Aggressive Indexes" was confusing, though, and always required a lot of explanation to demystify it. These issues are tough enough for database pros to understand, let alone putting 'em through another layer of abstraction.

In addition, this language can be off-putting for folks, and we'd rather use inclusive language.

So I'm going to:

  • Keep links intact during changes (not change these terms in URLs)
  • Change terms like sanity, insanity, addict, holic, phobic, medicated, etc to be more inclusive

This change was originally proposed by @eliprairie, but starting a new issue to track it because I'm going to do it slightly differently.

@BrentOzar BrentOzar added this to the 2023-05 Release milestone Apr 16, 2023
@BrentOzar BrentOzar self-assigned this Apr 16, 2023
BrentOzar added a commit that referenced this issue Apr 16, 2023
Working on #3250. Took @eliprairie's work, merging it with the current sp_BlitzIndex code.
@BrentOzar BrentOzar removed this from the 2023-10 Release milestone Oct 10, 2023
@SeanKilleen
Copy link
Contributor

SeanKilleen commented Jan 16, 2024

Updating this to track the individual suggestions so that we can do small, targeted PRs instead of #3251 that has been sitting stale for a bit with some merge conflict risk.

  • General text: Insanity -> Problems Language Sensitivity: Insanity -> Problems #3423
  • IndexSanity -> IndexIssues IndexSanity -> IndexIssues #3437
  • IndexPartitionSanity -> IndexPartitionIssues
  • IndexSanitySize -> IndexIssuesSize IndexSanity -> IndexIssues #3437
  • index_sanity_id -> index_issue_id IndexSanity -> IndexIssues #3437
  • Multiple Index Personalities -> Key Duplication or Near-Duplication Issues
  • Aggressive Indexes -> Locking Issues
  • Index Hoarder -> High Number of Indexes
  • Abnormal Psychology -> Current Index Structure Not Recommended
  • Self Loathing Indexes -> Index Usage Problems
  • Indexaphobia -> Missing Indexes
  • Functioning Statistaholics -> Statistics Info
  • Serial Forcer -> Serialization Issues
  • Addicted to Nulls -> Many Nulls
  • Addicted to strings -> Many strings
  • Feature-Phobic Indexes -> Underutilized Features
  • Workaholics -> High-Usage Indexes
  • Medicated Indexes -> Sequential Key Optimized

@BrentOzar let me know if these all need to be done in one shot and I'll update my newer PR to include them as desired.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants