In addition to the previous, the padding has changed on SQL 2016. It will pad with 0000, 3333 or 6667, depending on the value of the DATETIME. I suppose that...

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