Hugo Kornelis (11/27/2012)

---

That is a very polite way to put it.

I'll be more clear: the explanation is rubbish! The...

Nice basics question.

Odd sort of explanation though - maybe the author thought the references explained it well enough that he didn't need to say anything himself about why the...

CELKO (11/22/2012)

---

My question is: is it better to have all of these key lookups happening or would it be better to just build the clustered indexes on the UUIDs? ...

Nice question - and a reminder to me to use STUFF more often.

I don't understand why the explanation worries about the result length. . I agree with John Arnott's comments...

:blush: One of my thicker moments! :blush:

dave-L (11/21/2012)

---

Thanks for your help opc.three.

One last thing: I hate to leave less than optimal code out there for posterity so here is my last, optimized function with all...

jasona.work (11/21/2012)

---

paul.knibbs (11/21/2012)

---

Can someone explain in what way SNAPSHOT doesn't meet the stated requirements? That's the answer I selected and I always like to know exactly how I've been a...

It's not STR that produces the strange effect. If STR...

Nice back to basics question.

Unfortunately, knowing what the isolation levels are has never seemed to make people understand when to use which of them. Using read committed when what...

Stewart "Arturius" Campbell (11/20/2012)

---

L' Eomot Inversé (11/20/2012)

---

The real problem here is that we asked to choose 3 options, but in fact one of the options we must not choose is...

call.copse (11/20/2012)

---

I didn't see anything about that much either - it seems...

Kenneth Wilhelmsson (11/19/2012)

---

Just noticed the thread is a bit dated, but it seemed there was no real answer...

Why make it so complicated?

As per OP's request he just wants single chars...

I agree with many of the earlier comments. The only good thing about this question is the debate it provokes - plus it may discourage people from careless use...

A lot depends on how frequently new groups are defined, how frequently group definitions change (whether by adding new members or removing existing members or adding new subgroups or removing...

Jeff Moden (11/17/2012)

---

I've run into that same kind of garbage before. In fact, I worked with several different sets of...