And once again, Steve's proof-reading skills prove somewhat lackadaisical 😛

And time to get coffee 🙁

Steve has too much on his hands.

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....