Well, that is about 12 times faster on my machine. Where did you pick up that trick?

I need to delve a bit more into it now.

Ocular proof

Steve Jones - SSC Editor (8/18/2011)

---

Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal...

Testing it now - on a puzzle with fewer givens.

I would start with setting it at 4, test, baseline and then try a different value if necessary.

ColdCoffee (8/17/2011)

---

SQLRNNR (8/17/2011)

---

I have seen it many times more often in a CTE than the older Derived table. I think this syntax has some usefulness when thinking through it....

Some people need to get a clue.

Anybody want to chime in on this cheater?

Again - why the need to attack?

Think through the problem with a bit of logic.

If you didn't have a typo in the...

Seriously?

You come to a forum where people volunteer their time to ask for assistance with YOUR exam?

The answer is obvious - talk to your prof about it....

Thanks for the article Tony.

awu (8/17/2011)

---

From BOL:

"The maximum value for thedegree of parallelism setting is controlled by the edition of SQL Server, CPU type, and operating system. If a value greater than the...

Are the values you input into the table what was presented on the exam?

I have seen it go both ways. It depends on the query and how the results are being displayed or not displayed.

opc.three (8/17/2011)

---

Alex Webber (8/17/2011)

---

Thanks for the reply. This is actually backing up to box in the same data centre which we then copy offsite afterwards.

Also, like I said before, I...

That depends, if

SELECT price, quantity FROM orders WHERE quantify BETWEEN 50 and 75;

Is accurate, then none of the above is correct.

But if you mean this:

SELECT price, quantity FROM orders...