[font="Verdana"]Okay, I understand that the table will "suffer a lot of deletes". I'm not sure why that requires such a bizarre key format.

Provided you are still getting sequential or...

[font="Verdana"]What, is it America's Cup time again?[/font]

[font="Verdana"]CTE stands for Common Table Expression. You can call it anything you like, you don't have to call it CTE.

Post your code and we'll have a look at it.

[/font]

[font="Verdana"]What have you tried? Mark posted some code above, and there's several pieces of code in the article I linked to you.

Basically, the median is the "centre number" in...

Lynn Pettis (6/14/2009)

---

Any one interested in the Troll Name Site, I already checked it out. Although interesting, I sorta expected something a little different. Some of the names...

[font="Verdana"]It really isn't safe to be walking goats across the bridge today.[/font]

Alvin Ramard (6/14/2009)

---

Yes we do, but mostly in other threads.

In this thread it's multiple topics and...

Paul White (6/14/2009)

---

For those too busy to try it for themselves:

Alvin Ramard = "Tie Me To A Tree & Make Me Squeal Like A Pig Troll"

Jeff might want top steer...

Lynn Pettis (6/14/2009)

---

I will state again for the record, there are no cliques here on SSC. We are a...

[font="Verdana"]Wow.

I suspect that you are getting a comma-separated list of values, and you don't know how many columns you will need to store the data until you get the list?

Anyway,...

[font="Verdana"]Jeff: it's a great article, and the fundamental basis for so many optimisation techniques that I have seen you and many other people talk about.

I have to say that it's...

RBarryYoung (6/11/2009)

---

Hey, Gail (or anyone else either), if you get a chance could you check out this thread on SO for me? I'm sure that I'm right about the...

[font="Verdana"]Statistical medians aren't as easy to calculate as you might think.

You might want to start by having a look at Joe Celko's excellent article on the topic: Median Workbench[/url]....

[font="Verdana"]Agreed. 2mb is far too large. You shouldn't ever need a temp database...

[font="Verdana"]So you're saying everything in moderation, including moderation?[/font]