pmadhavapeddi22 (3/7/2014)

---

Disclaimer : Please excuse me for the delayed attempt for these questions

I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3...

Revenant (3/4/2014)

---

Tom, as I said, I have a stake in this - I would like to see these issues clarified -, but I am not the one to clarify them....

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Hmm... I am not a computer scientist and even less a programming language designer; however, I see that there could be a new rule introduced that...

Revenant (3/4/2014)

---

Hmm... I am not a computer scientist and even less a programming language designer; however, I see that there could be a new rule introduced that would say that...

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

For SELECT DISTINCT, allowing ORDER BY to operate on columns not in the SELECT list would produce erratic and unpredictable behaviour. Consider this table:

Col1 | Col2

-----+-----

...

TomThomson (3/4/2014)

---

Nice question.

Hugo Kornelis (3/4/2014)

---

Koen Verbeeck (3/4/2014)

---

Nice question, but the explanation doesn't mention why the order of casting vs order by changes. (because of adding the T alias in the...

The ORDER BY...

I *almost* got it wrong, ...

It *has* to work this way for subqueries, otherwise all...

I don't understand the question, and I think it's not even a question at all.

So we have two databases "with size of 50GB". Is that the size of the data...

I had it right, for the wrong reason. I expected an error because the first "root" node contains an XML fragment with multiple nodes, not a singleton. So I expected...

L' Eomot Inversé (1/27/2014)

---

(I only remember what NOLOCK is called because so often I've discovered it as the source of a bug and had to tell people to stop abusing...

L' Eomot Inversé (1/26/2014)

---

I can't remember what happened to the locking hint that said "ignore exclusively locked objects when reading" as opposed to "ignore exclusive locks when reading" - does...

L' Eomot Inversé (1/25/2014)

---

Yes, it is - and that means that the ability of a...

All definitions of the D in ACID that I found specifically mention that the information survives "even in the case of a system crash". (Which makes sense; information not spontaneously...