IIRC (and I NEVER give clients on-the-record advice about licensing due to the inherent liability of doing that) if a server has N cores you MUST license ALL of them...

Find a copy of "SQL Server MVP Deep Dives 2" (which was created and sold as a charity benefit) and read my chapter entitled "Death by UDF". There are umpteen...

BTW, are you seriously saying you want your CPU utilization to be LOWER?? I sure hope I misread that.

Low CPU usage (regardless of core count) is almost ALWAYS attributable to two things. Not enough RAM (common) and not enough IO bandwidth (almost ubiquitous in my 20+ years of...

That is an awesome response Jeff!! Thanks. Worthy of an article actually, but it (kinda) sadly wouldn't benefit many people because hardly anyone uses MARS (THANKFULLY!!).

I am quite...

It is quite common at my clients to have a secondary standby server with lower capabilities than the primary has (sometimes significantly less). It isn't a problem if you determine...

If the OP knows SSIS that can definitely be used to track the Order_ID and insert rows with the same value until the New_Order_ID <> Prev_Order_ID. Pretty straight-forward scripting to...

Depending on how much data you have this shouldn't be too bad, although as others say it is not a good design. But maybe from this you will take it...

Unless you are running VERY small databases, anything less than the maximum your version of SQL Server can run on (for standard edition it is 64GB pre 2014, 128GB 2014...

A) There's a lot of problematic things going on in this plan:
1) full scan, with some estimation problems  (see below)
2) a metric butt ton of cpu burning operations...

Just got a minute, so will try to slap enough together to get you there:

Move your SELECT into a CTE then do an UPDATE/JOIN to that

with...