The data still has to be read -- how else would SQL know that the proposed new value was the same as the value in the...

OK, found one of the links:

https://www.sql.kiwi/2010/08/the-impact-of-non-updating-updates.html

I assume Paul White is an authoritative enough source for you :wink:.

I mentioned another source in my ref notes but can't find it.  My internal...

The data still has to be read -- how else would SQL know that the proposed new value was the same as the value in the table itself?

It's the writes/dirty...

I'll have to check my internal notes for outer references.  My notes just have the relevant details for me, not where I got them from.

But I'm rather busy now, so...

The code below is showing the the exact same cpu times and statistics whether or not the target value is being changed.    Not calling you a liar,...

I agree.  In particular, I would never do this for "ANY" db.  And definitely not in production.  Prod data, particularly, should always be as tightly restricted as possible.

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, 11 months ago by ScottPletcher.