If a SAN snapshots aren't in the budget and compression isn't good enough (or not possible), read http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Technical%20Case%20Study-Backup%20VLDB%20Over%20Network_Final.docx.

The model database can be restored to other instances, but each instance must be running the same SQL Server build. And if the master database is rebuilt, the model database...

It may be worthwhile to think about a disaster scenario: If the utilities database goes offline, how many databases will be impacted?

Passing a delimited string certainly works. But I am currently working an issue where one sproc uses STUFF FOR XML to create a delimited string. A second sproc accepts and...

No idea. If one of those steps is a CmdExec job step, a wild guess is that the step's command-line executable successfully ran, but raises a non-zero return code (which...

Add a fictitious server name

Before going down the "pass an array as a string" path, I think the alternatives are worth considering. A good compendium is How to Share Data between Stored Procedures. I...

I don't think it is possible to reference a database's/catalog's objects within another database's object definitions (even if the other database/catalog is TRUSTWORTHY), but I am always willing to be...

set nocount on

create table MyTable

(

StrSource varchar(19),

SQLNo decimal(19,10),

EngFormat varchar(11)

)

go

create trigger StrFormat

on MyTable

INSTEAD OF insert, update

as

insert MyTable

(StrSource, SQLNo, EngFormat)

select StrSource, StrSource,

CASE WHEN charindex('.',StrSource)>0

THEN '.' + replicate('0',len(StrSource)-charindex('.',StrSource))

ELSE '0'

END

from...

I don't have numbers to offer as a comparison.

Total_worker_time is the total CPU microseconds accumulated since the plan was last compiled. Because 3.9M == 3.9 seconds and its query takes...

How did you determine the job failed? Did you seen a red icon? Can you upload its image? Double-click the job, double-click a job step, and click the Advanced tab....

It is possible for the application to still work, but I believe you are saying the vendor won't support you. I assume the vendor had a good reason to say...

christy-720576 (11/13/2015)

Now they would like to add a Current Student Photo and fingerprint details (Which will massively increase the size of the data)

Is there a point where you should consider...

BCP's -t specifies a field (aka a column) terminator. To specific a row terminator, use -r;.

To debug replace

EXEC (@SQL)

with

PRINT @sql

You will see the SQL it generates.

You can copy a line back into a SQL Server Management Studio query window, and run it...