nice simple question.

But I'm worried that MS thought it useful to increase the number of non-clustered indexes allowed on a table from 248 to 999: that presumably means that they...

Interesting question and discussion.

I got it wrong (said 4) so I got my point. :w00t:

edit: But I'm still not sure whether the right answer is 1 or 2, even after...

Although pigs may fly, I'm fairly sure they would...

sort of thing

this

for

allow

doesn't

prediction

Alvin Ramard (10/1/2010)

---

Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th, 2010.

...

Alvin Ramard (10/1/2010)

---

Craig Farrell (10/1/2010)

---

What's that, Baud 1...

Two interesting things here:

The first is that the BoL page referenced in the explanation has incorrect information on it: it quite clearly says

A computed_column_expression is deterministic when one...

The correct answer "It depends" isn't available as an option.

How many rows are produced depends on the IMPLICIT_TRANSACTIONS setting.

If ANSI_DEFAULTS or IMPLICIT_TRANSACTIONS have been set on, this code...

Jeff Moden (9/29/2010)

---

Nope... it's usually because some manager made a promise in a 60 second elevator ride or over drinks with the boss. A lot of times an "I'll...

East side of Michigan - anywhere between Detroit and Port Huron? That's the...