tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
The SQL for retrieving statistics that need updating can return duplicate records. The current SQL is: ~~~~sql SET @sqlcmd = 'USE ' + QUOTENAME(@dbname) + '; SELECT DISTINCT ''' +...
**Section => Index_and_Stats_checks - Sub-Section => Statistics_to_update** ***Uses Dynamic Management Views => sys.dm_db_stats_properties*** Disabled Indexes can be included and when they are included they are not properly cited. To excluded...
msdb does not have operating permissions, so use other databases
XML conversion error under SQL Server 2012 and SQL Server 2016 and when collation of the server was FRENCH_CI_AS. Using NVARCHAR instead of VARCHAR helped to resolve the issue.
Hi Team, I'm getting the following issues: Report: Daily Performance Trend Issue: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'PerfCtr'....
Add DROP PROCEDURE for automated installs of this procedure.
Hi JocaPC, first of all thank you for this valuable code. When exececuting against a database with multiple transaction log files, it just takes the last one from the resultset....
Irony time! Running `AdaptiveIndexDefrag` will result in exactly 1 fragmented index: `tbl_AdaptiveIndexDefrag_Stats_log`. Added a 4th step to the daily maintenance job to rebuild said index so that any monitoring system...
c1.value('@EstimateRewinds','int') AS EstimateRewinds, For SQL Server 2008 - 2016 I'm getting the following error. 2017 doesn't appear to be an issue Msg 245, Level 16, State 1, Line 2 Conversion...
It was included the return of fragmented indexes that have fill factor with 100%. This situation could cause impact on indexes with high volume of updates that could generate page...
