You also may need to force refreshing your query. You may find that it doesn't show things quite as aggressively as you'd like. (Assuming I'm understanding exactly what...

Jeff Moden (3/15/2008)

---

Rethinking this, DTS would probably...

So I'm NOT the only one quoting Pat Morita....:)

WITH ROLLUP would do the trick only if the intermediate results were also sums. Without it - it's actually going to be easier to do that using a UNION...

Ah - SSIS makes all of the difference. I didn't catch the fact that it was in SSIS at all.

By the way - have you checked this out yet?...

Are you sure you set the partRange derived column to return Bigint values? Because your WHERE clause is acting like it's character data. (assuming you've actually put in a WHERE...

Did I just see him mention that there were at most 60 TEXT fields? As in TEXT, not varchar?

Wow...that's going to hurt.

Adrian Hains (3/16/2008)

---

Carsten Petersen (3/16/2008)

---

What I've come up with until now. Any comments on it (performance etc.)?

CTE Returns Primary Key, Row Number and Total Record Count to @PagerTable, and is...

I'll answer the question with a question..:)

What does

SELECT DATEADD(m,-12,getdate())

show you?

By the way, Barry - don't give up ranting...You're good at it! I will also be checking that link you mentioned previously (as to the summarized standards ).

We can...

By the way Kaitong -

I'm hoping you're testing what's given to you, enough to understand it. There's a little twist you need to realize with what Barry gave...

rbarryyoung (3/17/2008)

---

Jeff Moden (3/16/2008)

---

Thanks, Matt... that'll teach me... I normally do a lot more research and "due diligence" before I post an article. I got in a hurry this...

you can also get a lot more specific info using some of the standard reports available in 2005's right-click functionality (appeared in Sp1 or 2?). Things like physical space...

Jeff Moden (3/16/2008)

---

Ok, folks... I was operating on some old experiences with correlated sub-queries... Hugo and Barry's posts made me look deeper and, after studying the actual execution plans in...

rbarryyoung (3/15/2008)

---

*sigh* Implication by Association. You should not be passing judgement on the SQL group based on the actions of two completely different groups, especially when you haven't...