Thanks for the response so far guys :). 

Andrew, that simply returns 1 for everything.

Chris, that gets close, but it is ordered alphabetically by field 1...

Thanks for the responses everyone :).

@sachin; you are right I named that strangely. It should be called, AvgbyYearbyAccount. I called it this because the account is the...

Thank you Jeff 😀

that was pretty much the solution I had devised already but it felt rather hard-coded and not very resilient to change so I thought there may have...

That is what I figured but wanted to be clear on that just in case. As for the levels right now there will be a total of 5.

Ah yes there are in fact 1 to many relationships between the tables so there are Ids that link them together, I just don't want/need the resultant Ids on the...

Thank you for the articles Luis, most informative! I also now know what I am looking for and referencing 🙂

Jeff, after reading your articles, I understand now what I am...

I finally figured it out!

So to the previous questions first and foremost...yes the Select statements were exact.

I did run the new stats with FULLSCAN on both systems. I...

Also, to make sure I was using the exact same script, I actually took the script from production and pasted it into a query in test and ran it, and...

That is odd that the merge should be faster than the hash, since if I add hash to the join (i.e LEFT HASH JOIN) it executes in half the speed...

Both...

Ah yes sorry bad habit. Yes I tried it with the backslash, I have no idea why I put the / slash but I just do that sometimes 😀

There is...

I believe Paul B answered best but I will reiterate; why does a Data Warehouse need to be built in this instance?

You could probably create a linked server to...

Also, the Data Warehouses I have been dealing with are roughly 150GB to 200GB for reference. They compress to about 15GB to 20GB. Depending on your physical server hosting this...

Hi Mark 🙂

If you are doing the typical once a night ETL refresh of data then a simple nightly backup work.

The Recovery Model I use is Simple as...