Jeff Moden (10/28/2011)

---

J Livingston SQL (10/28/2011)

---

Ok...got the test data now (dev machince at work 🙂 )

have you any performance figs...you say your query is "slow"...based on the test data...

J Livingston SQL (10/28/2011)

---

Ok...got the test data now (dev machince at work 🙂 )

have you any performance figs...you say your query is "slow"...based on the test data what response...

I just dropped the tables and rebuilt them using that code, and it took just under 5 minutes to run. I was starting to wonder if I'd accidentally posted code...

J Livingston SQL (10/28/2011)

---

Jeff Moden (10/28/2011)

---

Nope. Good to go here. My only other question is how many rows does your test data jig create? I started it...

GilaMonster (10/28/2011)

---

Kiara (10/28/2011)

---

Gianluca Sartori (10/28/2011)

---

Apple computers can provide up to 1100 mA at 5 V through the USB port when an Apple peripheral or device is connected directly to the...

A little over 14 million. But I didn't see anything like that kind of tempdb growth... My current test tempdb is only about 8 MB with 6 MB free.

Gianluca Sartori (10/28/2011)

---

Apple computers can provide up to 1100 mA at 5 V through the USB port when an Apple peripheral or device is connected directly to the port (no...

GSquared (10/28/2011)

---

Kiara (10/28/2011)

---

GSquared (10/28/2011)

---

Touch is faster than mousing, but since I use a trackball with four buttons and a scroll-wheel that can act as a fifth button, touch doesn't anywhere...

GSquared (10/28/2011)

---

Touch is faster than mousing, but since I use a trackball with four buttons and a scroll-wheel that can act as a fifth button, touch doesn't anywhere near that...

Jeff Moden (10/28/2011)

---

How many rows does the real table have? And I probably missed it above but what is the actual DDL for this table and any indexes it...

GilaMonster (10/28/2011)

---

Kiara (10/28/2011)

---

Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can...

ChrisM@Work (10/28/2011)

---

There are a couple of things I want to confirm using your data.

Firstly, IIRC aggregating the columns separately then adding up the aggregates is quicker than aggregating the...

ChrisM@Work (10/28/2011)

---

Kiara (10/28/2011)

---

ChrisM@Work (10/28/2011)

---

No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these...

WayneS (10/27/2011)

---

Kiara (10/27/2011)

---

Stefan Krzywicki (10/26/2011)

---

What dont you like about it? Everyone I...

ChrisM@Work (10/28/2011)

---

No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes at...