Error Index Compression
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 35/100
Research direction
Start with the AdaptiveIndexDefrag debug output and the rebuild-command construction at line 1941 mentioned in the report. Reproduce on the stated SQL Server 2005 version, then trace both the empty DATA_COMPRESSION value and the sysdatabases row-modification error; done means the reported commands execute without these errors.
Written by the indexing model from the issue text.
Description
Hi!
Some issue running on SQL Server, follow inormation:
Executing AdaptiveIndexDefrag v1.6.7 on Microsoft SQL Server 2005 - 9.00.5324.00 (X64)
Aug 24 2012 18:28:47
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Tryed Debug mode and found those two messages:
Message 1:
ALTER INDEX [ix_xxxxxxxxxxxxxxxxxx] ON [xxxxxxxxxxxxxxxxxx].[dbo].[xxxxxxxxx] REBUILD WITH (DATA_COMPRESSION = , FILLFACTOR = 90, SORT_IN_TEMPDB = OFF);
Error 102 has occurred executing this command. Message: Incorrect syntax near ','. (Line Number: 1)
Message 2:
Error 911 has occurred while determining row modification counter. Message: Could not locate entry in sysdatabases for database '[xxxxxxxxxxxxxx]'. No entry found with that name. Make sure that the name is entered correctly. (Line Number: 1)
For workaround on Message 1, I replaced line number 1941 / SET @rebuildcommand = @rebuildcommand + N'DATA_COMPRESSION = ' + @currCompression + ', ') with: SET @rebuildcommand = @rebuildcommand
- Dominant language
- Jupyter Notebook
- Stars
- 1.6k
- Forks
- 749
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/tigertoolbox
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
microsoft/tigertoolbox#320 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
microsoft/tigertoolbox#199 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 48/100
microsoft/tigertoolbox#319 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
microsoft/tigertoolbox#312 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
microsoft/tigertoolbox#311 ·
All issues in microsoft/tigertoolbox
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100