tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
Error 515 has occurred. Message: Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log'; column does not allow nulls. INSERT fails. (Line Number: 2113)
Fixed a case sensitive issue on line 160 changed i.[ix_handle] to I.[ix_handle]
This is not really an issue I am posting. I just have questions about AdaptiveIndexDefrag: 1. By default the script creates the objects that AdaptiveIndexDefrag needs in the system database...
I ran this with all of the log files, it was running for 6+ hours. "Saving results to JSON File." I removed all of the log files except for the...
One of my customers has more than 800 files and 2 log files (ID > 255) per database and the script crashes with tinyint
Failing with error Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()' because it contains a character (0x0000) which is not...
In the original version you have either the option to defrag only the right partition or all but the right one, which is good for sliding window partitions, or defrag...
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...
Removed problematic references using square brackets in dynamic SQL commands. This was also causing object names in log tables to also include the square bracket causing non-indexed statistics to fail...
One of my customers has more than 800 files per database and the script crashes with tinyint