lmu92 (6/28/2009)

---

But how about the method I posted above (let's...

Florian Reischl (6/27/2009)

---

I read your really good article and did my own tests. If multi-aggregated results are required the cross-tab solution is much faster than pivot. But in case of...

Me too. I'm really quite anti-PIVOT myself (as I have said at least once earlier on this thread) but I...

Hey Lutz,

My results were the same as yours; and I agree with your assessment.

Clearly, in this case, and with this data distribution, there is nothing to choose between the three...

Here is a test rig to try the various methods on the traditional one million rows.

(By the way moving a sub-query like this to a common-table expression generally results in...

I'll go with the simpler one then 😀

Anyhow, it seems the thread has it's answer and we have...

Grant Fritchey (6/26/2009)

---

I tracked down some more information. According to a Microsoft developer I spoke with, the determination for parallelism is made in the optimizer. BUT, there are functions &...

Have fun whatever you're doing. I'm sure we'll all try hard to be extra good....

I read it as constructive criticism :-)...

It depends...

Credit where it's due for giving it a go. 🙂

I agree that you should personally test code you post - for credibility's sake.

Paul

Hey guys,

'Pandian S' posted what I believe is the correct answer...in case you missed it in all the excitement there 😉

Paul

GilaMonster (6/26/2009)

---

Sure you're not thinking about table variables? Temp tables are visible in the procedure that created them and all procs/dynamic SQL called from there. They're only dropped when the...

OBJECT_DEFINITION works nicely for views.

You can also look in the definition column of sys.sql_modules - join from sys.views to see only the view definitions.

Paul

Hey mazzz,

Take a look at the huge library of generally useful scripts also available for free on this very site - see the scripts link on the sidebar

<--- over there!

Paul

P.S....