Well, that depends on your setup.

1. When was the record you deleted added/inserted into the database?

2. When was your last backup?

Now your just being mean Jeff ... LOL 😀

Correct me if I'm wrong, but isn't your first part nothing more than RBAR and the second true SET Based?

😛

[EDIT/UPDATE] --> ...

OK, now it's my turn to throw a stick in the wheel. *maybe*

Wouldn't physical/logical reads and such depend on the platform, disk/file or memory structure you have set up for...

Jeff Moden (11/13/2007)

---

In what way? Not necessarily looking for an example, but how were they...

*Laughs* you might want to look at the query again Matt....

Matt, Why do you say it's not getting the same results. I get the same results on my box?

Oh, and a side note. I'm not necessarily jumping on the band...

OK, so the final results (at least from my tests...)

---

With Cross Apply, PK and Included Column Index:

SET STATISTICS IO ON;

SELECT

t1.ndex,

t1.twodigit,

...

Jeff Moden (11/13/2007)

---

Yes, I used the tally table (or as you named it (myNumbers).

I didn't realize you wanted the Clustered index removed for the test.

So the new results with...

Hey all, I just realized how confusing my posts might have been, so I've went back and added the code I used to run my tests into my previous posts.

Hope...

HOLY SON OF A .. %&@$#@ !!!!

I never imagined the recursive CTE would be perform so poorly...

The recursive CTE solution WITHOUT the Included Column index:

SET STATISTICS IO ON;

WITH ...

Yes, I used the tally table (or as you named it (myNumbers).

I didn't realize you wanted the Clustered index removed for the test.

So the new results with the PK removed:

SET...

Peter Larsson (11/13/2007)

---

Jason, would you mind run the tests again with this index for testdata table?

CREATE UNIQUE NONCLUSTERED INDEX [ixu_testdata_ndex_incl_tenpower_twodigit] ON [dbo].[testData]

(

[nDex] ASC

)

INCLUDE ( [tenPower], twodigit )

WITH (INDEX...

Peter,

I'll get that later today 🙂

Yeah, and I'd really like to see the colors from EM/QA preserved in the posts to. But maybe I'm being picky.....

SELECT

cod

FROM

yourTable

WHERE

yourValue BETWEEN liminf AND limsup