Defrag Index Script
uspDbaIndexDefrag xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog
Update Statistics SQL Job
Should schedule during off hours. Type: Transaction-SQL script (T-SQL) Database: master Command:
DBCC CheckDB SQL Job
This job should be ran weekly or monthly. Not recommended to run daily as it can take a long time. Type: Transaction-SQL script (T-SQL) Database: master Command:
Remove Database Backup Files From SQL Job
SQL job to remove bak files older than 2 days for a folder. Type: PowerShell Run as: SQL Server Agent Service Account Command:
SQL Server Error 605
Error: SQL Error 601. Could not continue scan with NOLOCK due to data movement. SQL Sever Logs: Message Error: 605, Severity: 21, State: 3. Message Attempt to fetch logical page (13:2769683) in database 7 failed. It belongs to allocation unit 72057594291945472 not to 72057594369933312. Explanation This error generally signifies page or allocation corruption in the... » read more
SQL Server blocked access to procedure sys.xp_cmdshell
Error: Fix: Sources:
SELECT failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’
Error: Msg 50000, Level 16, State 1, Procedure uspXXXXX, Line 581 [Batch Start Line 2] uspXXXXX | SQL Error 1934 at line 505. SELECT failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query... » read more