sql-server-maintenance-solution

sql-server-maintenance-solution copied to clipboard

@@servername and SERVERPROPERTY('ServerName') are the same, only case is different

4

**Description of the issue** Backup scripts don't start as described on your site : "Added a check in DatabaseBackup that @@SERVERNAME is the same as SERVERPROPERTY('ServerName'). The check is only...

PekeDBA

Add a job that only updates statistics

1

**Add a job that updates statistics without doing index maintenance** I publish a script that creates a job to do this here: https://github.com/erikdarlingdata/DarlingData/tree/main/OlaStatsOnly I think it would be good for...

erikdarlingdata

Ola Hallengren Index maintenance on servers with Availability Groups

8

Message Executed as user: SRVR\SQLEng_SPArchO. ...ge 50000) Server: HDB-SP-SQL02\SQLSP02 [SQLSTATE 01000] (Message 50000) Version: 14.0.3401.7 [SQLSTATE 01000] (Message 50000) Edition: Enterprise Edition: Core-based Licensing (64-bit) [SQLSTATE 01000] (Message 50000) Platform:...

mirzahabeebdba

DDBoost error using SQL agent with redirect output to log feature

5

**Description of the issue** Error: Msg 0, Sev 0, State 1: Unknown token received from SQL Server [SQLSTATE HY000] String data, right truncation [SQLSTATE 01004] Msg 16389, Sev 16, State...

stevensgg

Added to code to be able to REBUILD heap tables, it's an optional parameter that defaults to 'N'.

tboggiano

I asked my dba in training to make a backup of a large database using dbo.DatabaseBackup and he said it was taking a long time and he wanted to know...

JohnMTrollope

Polybase Stats Rebuild Fix

4

Per Microsoft, statistics for external tables cannot be ALTERED. If a rebuild is required, they must be dropped and re-created. As such, I've updated the code to correctly identify external...

heaivilinn

I run a diff backup every day for all my databases. It changes to full backup if 50% or more is changed. For small databases I don't want to run...

wfvdijk

Update IndexOptimize - Add @TimeLimitEstimateCommandDuration (options: Min,Avg,Max) - Estimate duration of index and statistics commands for an object - skipping if the current time + duration exceeds the time limit....

siweston

IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds

1

If a time limit has been set some indexes or statistics operations could end up running over due to the size and how close to the end of the window...

siweston