GilaMonster (9/9/2011)

---

Oh, this fails too, but the complexities of nested (not) transactions is maybe overkill for a QotD (unless you're doing a 'what does this return' question)

BEGIN TRANSACTION Tran1

INSERT INTO...

That it doesn't show any buggy behaviour in 2008 R2(SP1).

But, on...

Ninja's_RGR'us (9/9/2011)

---

Did I miss the memo where September 2k11 is bug month for sql server?

I think I found another one today. Please confirm this is an issue on your...

Nice and easy today.

Ninja's_RGR'us (9/9/2011)

---

So bottom line, 25 sec gets you maybe 2-5 failovers on a clustered server. I've heard they take only a couple seconds. But with such a little...

Ninja's_RGR'us (9/8/2011)

---

Five 9 means you are required to be up 99.999% of the time.

I'm not sure about my math on this but it would mean that you have roughly 26...

Gianluca Sartori (9/9/2011)

---

ALZDBA (9/8/2011)

---

I've seen systems where regular DWH processing is being halted during the load window.

This way they free up resources on the dwh server and run ETL at...

Paul, thanks for that excellent explanation and information about the optimiser.

Good question and answer.

But the behaviour still seems bizarre to me. Why should the loop join hint be taken to imply the (Force Order) option - if I want...

I'was just getting used to seeing Monday questions on...

Good easy question.

Of course it may be that the query processing could order the merge conditions in order of specificity. We did that with the pattern matching conditions of...

A Good question.

But I thinl it might have been a better question if some extra options (pairs of ACID properties) had been provided, to give people an improved chance of...

But of course one could say that the query processing ought to notice that there is no ambiguity in number 4, because any possible ambiguity is eliminated by the ON...

Good question.

I got it wrong. Q1 is obviously wroing, and I immediately concluded it was all about "order by" and just skim the rest for "order by" related errors -...

Matt Miller (#4) (9/6/2011)

---

Tom.Thomson (9/6/2011)

---

Look, we are taking about extremely well known and standardised notation here. Any string that means "the number which is the limit of the series...