I am thinking about the negative consequences of provisioning free space drastically high.

1. How much difference it will be in backup size and backup time

2. Restoring to the test...

Thanks.  That was awesome.  Told me a lot.

Random GUIDs are GOOD... But not like THAT!

First and as a bit of a sidebar, you good folks have done yourselves a pretty...

Spot on early suggestion, Piet!

The first time I looked at it, SO DID I. 😀

Again, nice use of the "Relational Multiplication" method!  I'm still thinking about...

Jonathan AC Roberts solved this problem very nicely using the fnTally() function to due the "Relational Multiplication of Rows".  If we tweak his good code just a little bit, it...

;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N) RunningTotal, * 
      from #TEMP1 t
 ...

I may have something wrong with my understanding of the problem but, according to the values you've provided,  there is no combination of fruits in case #1 where you...

I may have something wrong with my understanding of the problem but, according to the values you've provided,  there is no combination of fruits in case #1 where you can...

You've got multiple...

It’s not “scripting” that makes mistakes easier... The real problem is "urgency of an issue".  The same can happen when deploying code of any type. You covered what the real...

The answer is likely going to be found in the code that...

PowerShell.

Ah, my apologies.  No.  Have not gotten to this yet and I'm not sure about tonight because I have a presentation to give tonight.  Thank you for the reminder and...

Apologies for the confusion in relation to relaying my thoughts on the whole process, I think it's a bit tricky to vocalise. I think I'll implement it as it...

What I'm trying to ascertain here is if it's feasible to make the whole model temporal (i.e. all Fact tables & Dimensions) so it can be rolled back in...