Jeff Moden (8/9/2011)
Crackin' good read as always Jeff.
Thanks, Chris. Always good to hear from you.
I never noticed it before. Your signature line says you're a defender of moggies. We have 7 that we rescued from the streets. At one time, we had 15 of them, 4 dogs, and a rabbit and that was a little much. Even the dust bunnies got uncomfortable.
Nah... didn't get rid of any of them. They all died of old age. I think we've given good lives to something like 40 or 50 of them.
Father Christmas and the petting farm 🙂 I've rescued one or two in my time. Seven places yourself and your missus somewhere between charitable and saintly!
On first reading your article I was a little concerned that folks might write off rCTE's altogether, despite your very clear wording. However, it does appear that folks have picked up clearly that rCTE's are a profoundly poor choice for counting, not necessarily for other tasks.
Incidentally, did you notice during your tests how rubbish the stats are for rCTE's?
[font="Arial"]“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw[/font]
For fast, accurate and documented assistance in answering your questions, please read this article
Understanding and using APPLY, (I)[/url] and
(II)[/url] Paul White
Hidden RBAR: Triangular Joins[/url] /
The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden