Variables in CMD
TestScript.cmd Result What is your name: John Specify Project?: 123 Name=John Project=123 Press any key to continue . . .
Parameters in CMD
TestScript.cmd Result D:\>TestScript 1 2 First Parameter: 1 Second Parameter: 2 Press any key to continue . . .
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: