And also assume that it's original value for the HireDate falls within the CHECK...

Magnus Ahlkvist (9/15/2016)

---

I don't Think the correct answer is correct.

When I try to update a view (defined using WITH CHECK OPTION) with a value which makes the row fall outside...

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