tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
The definition of @ColumnStoreGetIXSQL is problematic on case-sensitive databases. In SQL, its definition is listed as @minPageCount_**In**. On the other hand, In @ColumnStoreGetIXSQL_Param, here is minPageCount is listed as @minPageCount_**in**...
In Stored Procedure dbo.usp_AdaptiveIndexDefrag, the @rodmodctr variable is currently declared as numeric (10,3). Please change its definition to bigint. This will match its actual definition in the sys.dm_db_stats_properties DMV. **Current...
I am trying to use usp_AdaptiveIndexDefrag (v1.6.9) to generate/view update statistics commands, but usp_AdaptiveIndexDefrag is not returning any. When I run usp_AdaptiveIndexDefrag with @debugMode = 1 I see errors. ```...
When deriving Windows Version, there is a piece of code that lumps windows release 6.3 and 10.0 together and sets it equal to 10.0. In SQL Server Version 11 thru...
I tried to run below command to rebuild index on one particular table. But it started rebuilding all the fragmented indexes in the database. EXEC dbo.usp_AdaptiveIndexDefrag @dbScope ='ABC', @tblName =...
Command: git -c diff.mnemonicprefix=false -c core.quotepath=false --no-optional-locks ls-remote https://github.com/microsoft/tigertoolbox.git Output: Error: fatal: unable to access 'https://github.com/microsoft/tigertoolbox.git/': SSL certificate problem: unable to get local issuer certificate any one got the same...
Selecting a statistic to update... Getting information on selected statistic... Determining modification row counter for statistic [PK_spotlight_playback_data] on table or view [spotlight_playback_data] of DB [SpotlightPlaybackDatabase]... Using sys.dm_db_stats_properties DMF... Error 911...
Hi, the usp_AdaptiveIndexDefrag_Exceptions.sql procedure removing spaces in table names, see the reference: https://github.com/microsoft/tigertoolbox/blob/0160f5e346582cdfadfed4b37daad87dfe31fa2b/AdaptiveIndexDefrag/usp_AdaptiveIndexDefrag.sql#L3279 My proposal is to replace "REPLACE(@exceptionMask_tables, ' ', ''): with "@exceptionMask_tables" only. I know its not a...
I'm able to execute SP without any issue if I've deployed directly from SSMS, But when I've deploy it using Powershell, SP created successfully and when i tried to execute...
Receiving below error :-- The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it...
