tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
ALTER INDEX [Akeygroupdata117_202] ON [OnBasePRD].[hsi].[keygroupdata117] REORGANIZE WITH (LOB_COMPACTION = ON); -- No need to update statistic [Akeygroupdata117_202] on table or view [keygroupdata117] of DB [OnBasePRD]... Error 8134 has occurred. Message:...
SAP for SQL Server recommends the following corruption alerts 601, 644(Not available), 823, 2511, 8928, 8944, 8952, 8976 of which the tiger team already has defined 823 & 2511
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.
I use usp_AdaptiveIndexDefrag on multiple Sql Server 2016 instances and have noticed that the size of the tbl_AdaptiveIndexDefrag_Analysis_log table grows over time. Most of time the table stays small but...
Option @printCmds states the following: @printCmds defaults to 0 (do not print all commands to screen) or optionally 1 (print all commands to screen). Useful if you **just want to...
Good morning I am trying to run the Fixing_vlfs script against an alwaysON Availability group but i get an error:  I run the script, but when it touch´s...
The results of the columnstore fragmentation calculation can be greater than 100 (lines 1247-1261), but the value passed into @rebuildThreshold_cs is capped at 100 (lines 492-493). This makes it impossible...
When a table is locked, reading from sys.dm_db_index_physical_stats cannot be run. So, the page lock of this step cannot be released. The solution is to apply SET LOCK_TIMEOUT before querying...
I tried out usp_whatsup on a SQL 2016 (13.0.5337.0) received the error. Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()'...
Currently the procedure runs per server, database, table. Would like to be able to submit index name to only defrag a single index. Use case: No maintenance window, defrags must...
