If someone were to ask me what normalization is during a job interview, that would be one of the mental check-boxes that I'd check of for reasons why I might...

Just my 2 cents...

1. I hate anything that has to do with making me type something extra.  And, no... I also don't use Underscores as a replacement character for spaces,...

See the following article by Brent Ozar and the links he has for some of Paul Randal's articles on the subject.

https://www.brentozar.com/archive/2020/06/page-life-expectancy-doesnt-mean-jack-and-you-should-stop-looking-at-it/

Save yourself some time... Look for Adam Machanic's "sp_WhoIsActive" code.

A single CPU going to 90-95% is expected.  Are you saying that the total of ALL CPU's is what's going to 90-95% or just one now and then?

If so, check...

Are Items A thru F all in a single parent-child table?

WARNING!  BEFORE YOU USE THE CODE LISTED ABOVE, PLEASE READ THE FOLLOWING!

If someone is looking for a code solution to ignore duplicates then, sorry, the code above shouldn't...

I get where you're going with that but I guess I'm going to have to put that to the test in the very near future.  I did it once out...

+1000 to ratbak on this one.

I'll also state that since you KNOW this is a type-0, why don't you submit a script to management to actually fix the bad data...

Ok, Shree23... I just want you to know that this is how you piss people off and they end up not wanting to help you.  Your first posted on anther...

Checking back in here.  The OP generated the 15 minute data from the recursive CTE and that's all the data they currently have?  As an aside: a recursive CTE...

It's probably a bad idea all the way around anyway.  🙁  How many people do you know that actually have a "Baseline" to compare against?

For me, it would work just...

I want to consider "Backup Size GB" and "DeltaNormal" columns and calculate percentage. I know the formula (difference/old_or_prev_val)*100.0 but I am stuck I am stuck how to compare the...

You have 2022-05-28 as a date in your desired output but no such date exists in your test data.

You get the same results with "CROSS JOIN #SubDetails SUB".

The code I posted is an abstraction / summary of some production code we were investigating recently. I'm just interested...