From the Article:

---

"I urge developers to have others look at what they present on the screen, and spend time learning from users, both experienced and novice. "

I've found that...

Thanks.  That's just fascinating to me because I've never seen such a thing before.

Any chance of you posting the TVF so I can try to make an experiment that duplicates...

Since you're right there and have a handy test setup, I'd be curious what happens with the same query with the comments in the following form...

SELECT SUM(results)

/* comment1 */

/* comment2...

Thanks, Peter.  Lordy... that's a bit crazy.  Apologies for asking and...

I also have to ask "WHY"?  Why do you need to "batch" this instead of just doing all 2 million rows, which most servers can easily handle?

And the reason why...

Thanks, Jeffrey.

Interesting... Just one more question, please... have you ever done a restore to test all of that (including log files)?  Knowing you, I'm sure you have but I've got to...

So what's with the "Copy Only" backups?  Those aren't your "Daily full backups" are they?

To be accurate, I cannot actually run differentials in this environment either because we backup the databases from the secondary and you cannot run differentials from a copy only...

@Jeffrey Williams,

How big is the largest server instance that you're doing the Daily full backups on?

Which Anti-Virus are you using, please?

And when you disabled the AV, did the odd entries for backups disappear, as well, or are they still appearing?

I smell spam cooking.

Just to play the devil's advocate here and make you think: 🙂

How do you want to handle if the date in Table A is right in the middle between...

You're welcome.  Were you able to fix your problem and, if so, what was the fix you employed?

My "general" recommendation for backups is...

1. Full Backup once per week.
2. Dif Backup once per day.
3. "Conditional" Log file backups every 15 to 30 minutes.

Of course, that's subject...