tigertoolbox
tigertoolbox copied to clipboard
microsoft
Toolbox repository for Tiger team
I am receiving the message Not partition number specific.. On a SQL 2017 database server. Any insight on why I get this message. I tried looking at the code, but...
Hi, Why doesn´t you include the version of SQL Azure in this check? `### /* Refer to http://docs.microsoft.com/sql/t-sql/functions/serverproperty-transact-sql */ IF (SELECT SERVERPROPERTY('EditionID')) IN (1804890536, 1872460670, 610778273, -2117995310) SET @editionCheck =...
Right now, it is not possible to update statistics only, without also defragging indexes.
Using @statsThreshold to force a sample rate on a table seems to have no impact on sample rate. For example using @statsThreshold = 30 on individual tables still results in...
Declare @ErrorNo Integer EXECUTE @ErrorNo=[dbo].[usp_AdaptiveIndexDefrag] @timelimit=720, @outputResults =1, @debugMode=1,@forceRescan=1 print @ErrorNo if (@ErrorNo
Script tries to run `run('python -m pip install -m pip install azure-cli')` But I guess there is one "-m pip install" too many?
Downloaded latest failover detection utility on 2019-04-11 (exe modified on 2018-11-27 ) Gathered all log files together as outlined in the web instructions - https://techcommunity.microsoft.com/t5/SQL-Server/Failover-Detection-Utility-Availability-Group-Failover-Analysis/ba-p/386021 Followed the strong name workaround...
Is it possible to add feature to adjust the fill factor based on table usage pattern?
PS Script to identify the Subscription status of Bulk Registration for SQL Resource provider. Can be supplied with a list of subscription id's "-SubscirptionList" or no subscriptions to check status...
