No, only one mail account per job.

But you can group email account so that multiple people receive an email for the job.

I might be misinterpreting what you're saying above but, at face value, I have to...

Tempdb tends to grow enormously after turning on snapshot, since most shops update data fairly frequently.

Shrinkfile remains functional but it should only be used exceptionally rarely!  Such as after a major...

n/a.

You'd generally want to go: schemas (if any other than 'dbo'); tables, from least dependent to most dependent; functions; views; stored procedures; synonyms.  [For some of those you could change...

(3) SQL does that itself, so that's only a very minor consideration.

I too vote for One.

I assume the table has a unique key column(s).  If not, it will be very difficult to do what you want.

Your stated requirements seem to contradict...

My view is that the vast majority of the time row comp is beneficial, likely 90+%. So I think they're better off always doing it vs never doing it, which...

I(1) Other than re-write the script to update in batches, is there anything I could do to minimise the logging to the transaction log, or (2) a way...

• This reply was modified 4 years, 9 months ago by ScottPletcher.

I can't find right now the newer link for row compression recommendation, but here's the old one.  Of course, if your system is CPU bound, rather than I/O bound, you...

While row compression...

FacilityID - Decimal (12, 0) - takes 9 bytes - better to use a bigint - 8 bytes so I would look at this particular column to see if...

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

• table...

Yeah, that's basically it.  Although "changes written to mdf" is "changes to mdf made in buffers".  The mdf pages do NOT have to be written to disk for the trans...

Issue this command first:

CREATE SCHEMA config;