@ Evgeny Garaev ,

I totally agree that Ola's good code will take a huge number of different settings.  There's no argument there or on the quality of Ola's code.

The problem...

I can definitely vouch for that... in...

And, I...

Ok.  First of all, we need to get rid of the incremental rCTE (recursive CTE) that you're using to come up with the missing dates.  Please see the following article...

That, good sir, is an excellent post.  Thank you for taking the time to post it.  I'll be back. 😀

In that case, I don't have any good guesses.  The error message is pretty clear about it not being able to find the file.  I'm still thinking it's a privs...

I'm thinking that the services accounts for the new server have no privs on the target directory.  Fix that and you should be golden.

"Minor Issues"??? A multi-million dollar rocket crashing is NOT a "Minor Issue"! 😀  Neither is using a space vehicle for a planetary drill because of a difference in measuring systems...

For the love of Pete... why on Earth would you post your problem in a 2014 forum then?  Any other caveats you'd...

This problem is an interesting problem and so I built two tables each containing more than 102 Million rows spread across 5 years (60 months) with each month containing more...

So tell me where in pietlinden's script...

Hi  all,

need your help on conversion of excel formula into case statement. i tried but missing only one case. below is excel formula:

=IF(AND(Q141="EndOfDay", AD141="EndOfDay",V141=""),8, MIN(8, IF(OR(Q141="EndOfDay"), 0, IF( AND(...

The link for Jonathan's script, once you find it on SQLSkills, is broken.  Do you have another source for the script that makes the two sales tables larger?

Can you post the link, please?

The ANSI/ISO standards specify an extra clause that goes after the order of the sort (ASC | DESC) which will let you decide the order of the nulls within...