msdb indexes

Open
#88 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
30/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
sql
Domain
databases

Research direction

Start by locating the code paths that use the "WHERE mst.is_ms_shipped = 0" clause and inspect how index rebuild and reorganization targets are selected. Trace the existing maintenance options and their tests, if present. Done means an explicit option can include system-generated indexes in msdb without changing the current default behavior.

Written by the indexing model from the issue text.

Description

Suggestion: Include an option to allow rebuild/reorg of system-generated table indexes, specifically those in msdb. The "WHERE mst.is_ms_shipped = 0" clause used throughout the code prevents this.

Dominant language
Jupyter Notebook
Stars
1.6k
Forks
749
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/tigertoolbox

All issues in microsoft/tigertoolbox

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.