tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
Fixed case sensitivity issue smaller case i should be upper case i.[ix_handle] to I.[ix_handle]
A few updates and enhancements considering partitions, etc.
Hello! Today I executed the script against a SQL Server 2019 instance with Windows Server 2019 running on Azure VM but the results for the services account came incorrect. Checking...
Line 678 in view_IndexInformation.sql and line 698 for view_IndexInformation_CurrentDB.sql are aggregating for Key and included columns. Adding "and sic.is_included_column = 0" into the WHERE clause for the "KeyCols_data_length_bytes" column will...
Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 12.0.3 to 13.0.2. Release notes Sourced from Newtonsoft.Json's releases. 13.0.2 New feature - Add support for DateOnly and TimeOnly New feature - Add UnixDateTimeConverter.AllowPreEpoch property New feature...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 12.0.3 to 13.0.2. Release notes Sourced from Newtonsoft.Json's releases. 13.0.2 New feature - Add support for DateOnly and TimeOnly New feature - Add UnixDateTimeConverter.AllowPreEpoch property New feature...
`usp_AdaptiveIndexDefrag` logs incorrect duplicate objectId/objectName in `tbl_AdaptiveIndexDefrag_log` during stats update, however corresponding records in tbl_AdaptiveIndexDefrag_Working are fine. It seems code fails to update `@objectName / @objectId` variables and inserts the...
Read "Don’t optimize for ad hoc workloads as a best practice" by [Randolph](https://bornsql.ca/blog/author/bornsql/) and [Erik Darling](https://erikdarlingdata.com/) https://bornsql.ca/blog/dont-optimize-for-ad-hoc-workloads-as-a-best-practice/
The @sqlcmdRI variable used for versions > 14 checks the sys.idex_resumable_operations view. However depending on the length of the DBName being checked the current NVARCHAR(100) throws an error with the...
Hi , Can I use @Tblname parameter as 'SCHEMA_NAME.*' to run rebuild/re-org for entire tables specific to the SCHEMA only and exclude other schemas within the same database.
