Wouldn't this depend on whether the limit is set with MAX_CPU_PERCENT or CAP_CPU_PERCENT?

Yay! I got it right!

Stewart "Arturius" Campbell (4/15/2016)

---

Rune Bivrin (4/15/2016)

---

Ah, well. Got to read a bit about log shipping. That's worth something.

Is it only me who thinks Steve's error quota for QotD has risen...

Ah, well. Got to read a bit about log shipping. That's worth something.

Is it only me who thinks Steve's error quota for QotD has risen considerably as of late?:hehe:

patricklambin (4/7/2016)

---

But I was really interested by the others posts which learnt much about the differences between Great Britain and USA in language even if with the same name. So...

GAH! I hate double negatives.

Stewart "Arturius" Campbell (3/31/2016)

---

The MAXDOP setting will let the enginre use parallel processing where the optimiser considers it neccessary, alternatively, use the MAXDOP query hint (but definitely not on a...

Yeah, well I read it a bit too quickly, and couldn't quite accept the idea of a nullable...

It's somewhat interesting that the topic cited for reference disagrees a great deal with this:

MSDN EXECUTE (Transact-SQL)

Aah! Now I see it. Not specified when executing the SP, but when creating...

Hugo Kornelis (1/7/2016)

---

Hugo Kornelis (1/7/2016)

---

Rune Bivrin (1/7/2016)

---

Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up...

Hugo Kornelis (1/7/2016)

---

Also note that the syntax diagram suggests that not only the ORDER BY clause, but also the OVER clause itself is mandatory (though the text of the article...

Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up to SQL 2012....

Where can I buy SQL Server 2015?:hehe:

webrunner (11/10/2015)

---

I knew that...

Thanks for this one! Got it wrong and learned something quite useful.