Below Script work well for this cause, It will wait for the first job to complete and then star the next job.

EXEC dbo.sp_start_job N'JobName';
GO...

Don't keep the default, Set to 3 or 4 gb less than total memory on server. (Depends on Local server load and other applications run in back end) 

Did...

Better use the input column with Alias name like below, It will bring the extract in the order you wanted.

select
Name as Col01
, Age as Col02

Each and every connection required some memory allocation, Check for available free memory.

Please use below command to read the agent start time from Agent Error Log.

EXEC master.dbo.xp_readerrorlog 0, 2, "SQLSERVERAGENT starting under"

Yes, You can just add the the col_3 to the first index and its took care of both need.

Also, Before drop any index, look for indexusage statistics report. ...

Best approach could be for long term solution, Creat the VIP and VIP name for each server then the server name is invissible to application.

Its easy to manage when...

My personal thought, DBA's will not accept automating the patch update.

If we automate the failing over to other node, we should make sure the node back online and no...

Considering you have physical server and storage is SAN box.

If you are going to use the same storage and all your data and log file in SAN box. Build your...

Below script will generate the Insert script for all table from one particular db..

--Start

declare @TableName varchar(50)

declare tblcur CURSOR FOR

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE ='BASE TABLE' AND TABLE_NAME LIKE...