usp_AdaptiveIndexDefrag QUOTENAME(@dbName) issue

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

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
45/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
sql
Domain
database

Research direction

Locate the usp_AdaptiveIndexDefrag procedure and inspect the commands used when @DebugMode = 1, especially the nine QUOTENAME(@dbName) occurrences. Reproduce the row-modification-counter error with the procedure's debug mode and confirm completion when the stored database names no longer produce Error 911.

Written by the indexing model from the issue text.

Description

When @DebugMode =1 you have a few commands that contain
QUOTENAME(@dbName)
which are causing errors
Error 911 has occurred while determining row modification counter. Message: Database '[WAREHOUSE_STAGE]' does not exist. Make sure that the name is entered correctly. (Line Number: 1)

The QuoteName is unnecessary because its already quoted when stored in the
tbl_AdaptiveIndexDefrag_Stats_Working
table

There are 9 occurrences of these that cause problems.

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.