Viewing 15 posts - 766 through 780 (of 1,183 total)
Well, that depends on your setup.
1. When was the record you deleted added/inserted into the database?
2. When was your last backup?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 10:07 pm
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] --> ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 9:44 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 9:14 pm
Jeff Moden (11/13/2007)
I've found is that in some cases one is much better than the other two
In what way? Not necessarily looking for an example, but how were they...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 6:25 pm
Matt Miller (11/13/2007)
It's odd - because the CTE is giving me nothing but 1's in the ENGCount (not incrementing).
*Laughs* you might want to look at the query again Matt....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 8:57 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 8:45 am
OK, so the final results (at least from my tests...)
SET STATISTICS IO ON;
SELECT
t1.ndex,
t1.twodigit,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 8:00 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 7:45 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 7:12 am
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 ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 6:54 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 6:37 am
Peter Larsson (11/13/2007)
CREATE UNIQUE NONCLUSTERED INDEX [ixu_testdata_ndex_incl_tenpower_twodigit] ON [dbo].[testData]
(
[nDex] ASC
)
INCLUDE ( [tenPower], twodigit )
WITH (INDEX...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 6:17 am
Peter,
I'll get that later today 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2007 at 5:31 am
Yeah, and I'd really like to see the colors from EM/QA preserved in the posts to. But maybe I'm being picky.....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 12, 2007 at 10:46 pm
SELECT
cod
FROM
yourTable
WHERE
yourValue BETWEEN liminf AND limsup
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 12, 2007 at 11:38 am
Viewing 15 posts - 766 through 780 (of 1,183 total)