Viewing 15 posts - 61 through 75 (of 55,829 total)
I'm still thrown off by week 53. What? How does this work? This topic is the same as this other one I'm assuming
The week 53 problem is because...
June 14, 2022 at 5:56 pm
Ok... I've got the week number part down to a nice, high speed single formula. I need to add the year in but it' 03:17 here and I have to...
June 14, 2022 at 7:17 am
Quite contrary to popular belief, index REBUILDs are NOT a problem compared to REORGANIZEs.
Here's just one example. I had a table that had an ever increasing Clustered Key that contained...
June 14, 2022 at 5:17 am
For those interested, here's the profiler run I fan just a bit ago. It doesn't contain all the tests but it doesn't really matter because the extra tests just prove...
June 14, 2022 at 12:12 am
Format could be derived like this:
CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)You indicate output as "Rome Time". What timezone/offset is your source data in?
I would...
June 13, 2022 at 11:38 pm
Format could be derived like this:
CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)You indicate output as "Rome Time". What timezone/offset is your source data in?
I would recommend just...
June 13, 2022 at 9:49 pm
Sounds like the log file issue might be spot on according to the following link...
https://www.sqlskills.com/help/waits/preemptive_os_writefilegather/
June 13, 2022 at 5:34 pm
Thanks for the suggestions.
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...
June 13, 2022 at 5:05 pm
Thanks so much, Jeff, I will review those articles.
Thanks again!
-- webrunner
My disclaimer is that I don't know if that's the actual problem. It's just one that people seem to...
June 13, 2022 at 3:01 pm
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...
June 13, 2022 at 2:53 pm
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...
June 13, 2022 at 2:40 pm
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.
June 13, 2022 at 2:24 pm
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...
June 12, 2022 at 9:10 pm
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...
June 11, 2022 at 6:44 pm
Understood but you've not actually answered my question...
You say (or at least imply) that you want the first day of you your weeks to be on Sunday. If the current...
June 11, 2022 at 6:26 pm
Viewing 15 posts - 61 through 75 (of 55,829 total)