Viewing 15 posts - 54,106 through 54,120 (of 59,065 total)
Heh... you've hit SQL Server in it's weak spot... RegEx... I know that's what you'll build into your CLR and I've got a funny feeling I'm going to get my...
November 14, 2007 at 3:10 am
In the moving of the data I forgot a job that deleted from 1 table, so in a weeks time this table became hugh.
So... you all set now?
November 13, 2007 at 11:57 pm
Okidoki... I'm not a "Systems DBA" so anything I'd say would probably be wrong on this... so the following URL's are the step by step instructions on how to do...
November 13, 2007 at 11:43 pm
Data might not be gone if the database is in the "FULL RECOVERY" mode... can you check, please? Don't do a recovery, just yet...
November 13, 2007 at 11:32 pm
Absolutely! And to be fair, it IS a really extreme example... but put both pieces of code in a single QA window and run an estimated execution plan on...
November 13, 2007 at 10:24 pm
Actually - did you see my last post? Execution plan-wise, and processor effort-wise, CTE seems to be the "better choice".
Heh... they ALL say that until a job takes 8...
November 13, 2007 at 9:40 pm
I'll pick up that gauntlet.. How about we up the ante a little. Split the string, return the PK, the split value AND the index in the original string....
Heh......
November 13, 2007 at 8:56 pm
but we have others who are about to (use this to "gut" CTE's).
Like me! 😀
Heh... I don't need this thread to gut CTE's... most code examples that use them in...
November 13, 2007 at 5:58 pm
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 better?
CTE is...
November 13, 2007 at 5:38 pm
Vivien Xing (11/13/2007)
Comparing query performance from different server/SQL edition? It is supposed to compare based on the same server setting/configuration.
Isn't that like saying two different size dump trucks...
November 13, 2007 at 5:30 pm
Guess I'm just gonna have to document that proc from BOL... 😛
Andy, what the max number of parts a given assembly can have? There's a reason why I ask......
November 13, 2007 at 7:40 am
Grumpy... looks like you have PM disabled. Wanted to send you my cell phone number. Might be fun to get together and do some 12 ounce curls wilst...
November 13, 2007 at 7:36 am
HOLY SON OF A .. %&@$#@ !!!!
I never imagined the recursive CTE would be perform so poorly...
Heh... my work is almost done here...
Peter, did you have some...
November 13, 2007 at 7:32 am
... and what happened to the Cross-Apply Peter was talking about?
November 13, 2007 at 7:29 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...
November 13, 2007 at 7:26 am
Viewing 15 posts - 54,106 through 54,120 (of 59,065 total)