I would recommend just...

Sounds like the log file issue might be spot on according to the following link...

https://www.sqlskills.com/help/waits/preemptive_os_writefilegather/

Hi and welcome aboard.

Be advised that your post looks and smells like a precursor to spam.  If you're a spammer, please go away.  We're watching.

If your...

My disclaimer is that I don't know if that's the actual problem.  It's just one that people seem to...

I use the term "Legacy Backups" when I need to politically correct terms so as not to be taken to task for what some people would call a "Visit by...

The spam entry brought me back here.

@pekoms... you never got back to me on what unit of measure you wanted the result to actually be.

Just in case you still have...

Absolutely perfect.  That graphic explains it all.  I have a high performance idea on how to do this and I'll explore it tonight after work.

Jeff,

The above is the i/p which i receive my client which may having missing weeks data, so i need to populate 0 for missing weeks.

Also, actually it has two...

First thing I'd check for is the size of the log file being restored and then I'd check the original database to see the size and how many VLFs are...

Understood but you've not actually answered my question...

You say (or at least imply) that you want the first day of your weeks to be on Sunday.  If the current date...

Hi All,

I have the below query , have set datefirst as Sunday (7), but here i am getting week 52 for Sunday and Week 53 for Monday. I am...

You just re-stated exactly the first line of what I wrote in an earlier...

I considered submitting a request asking for a way to suppress the dark mode request.

I actually have to use DATEDIFF_BIG.  The fact they couldn't be bothered to implement the...

Or run the stored procedure yourself and email them the results in a spreadsheet.

Just remember that you'll end up with a rather huge transaction log file on Step 3 and it will take 2-3 times longer if you don't achieve "Minimal...