Viewing 15 posts - 54,091 through 54,105 (of 59,065 total)
Not sure, but I think dynamically creating a cursor is like dynamically creating a temp table... you may get it to work, but it'll likely be out of scope just...
November 15, 2007 at 2:54 pm
Sorry... must still have the "ranger eye's" going on from lack of sleep the other day... I just say the results you posted for the run.
Thanks for fixing my boo-boo....
November 15, 2007 at 2:34 pm
==============================================================================
The XML path() method
------------------------------------------------------------------------------
00:00:08:423 Duration (hh:mi:ss:mmm)
==============================================================================
Now... THAT's impressive! It reduced the processing time by almost 2/3rds. Rare thing when you find a gem like that. Thanks!
EDIT: ...
November 15, 2007 at 2:25 pm
No noticeable difference in processing time.
You mean on the dynamic SQL by itself or the whole Phone Test #1?
Thanks for the great tip (we call them "oolies" in the US...
November 15, 2007 at 2:22 pm
Oh, I will add in an additional challenge if you two feel like it.
Take data of the following form, with a lot, lot more data (say 100 000 rows and...
November 15, 2007 at 1:13 pm
Bottom of the page. It's actually a CSQ, but it seems to run like the wind with proper indexing (8 seconds re-concatenating the 3.54M phone numbers I extracted previously). Those...
November 15, 2007 at 10:47 am
Ok... first things first... after a (finally) decent night's sleep, I did the Phase II code for the phone number problem. Assuming you still have the Tally table active,...
November 15, 2007 at 9:50 am
Me too! Anyone know where there might be a posting for it? Or, maybe post it here so we can do some testing on it?
November 15, 2007 at 5:47 am
That KB article is what you'll find in BOL under "Expanding Hierarchies"...
November 15, 2007 at 5:31 am
Jason Selburg (11/14/2007)
Sorry everybody, but dewa's already said it's in Simple mode. :crying:
Yeah, I missed that. Oh well... at least Dewa has the links for a recovery using FULL......
November 15, 2007 at 5:18 am
==============================================================================
Matt's CLR Solution for Extracting Phone Numbers
------------------------------------------------------------------------------
(4040205 row(s) affected)
00:01:46:083 Duration (hh:mi:ss:mmm)
==============================================================================
Ok... I might have just missed in in your code and because of the rowcount you have (I know...
November 14, 2007 at 7:47 pm
--the unique index - not clustered since you're not doing clustered either
Boy! Talk about a typo on my part :sick:
November 14, 2007 at 6:18 pm
GilaMonster (11/14/2007)
Or if Jeff wants to produce the T-SQL, I can give the C# a try, but it won't be for a couple days.
Heck ya... great idea for a test,...
November 14, 2007 at 6:00 pm
Shaun McGuile (11/14/2007)
Good idea Gail, I'm not gonna get in the way of battling giants!:D
Matt said it right... "boys with their toys"... just having a bit of fun... c'mon in......
November 14, 2007 at 5:55 pm
KT (11/14/2007)
November 14, 2007 at 5:50 pm
Viewing 15 posts - 54,091 through 54,105 (of 59,065 total)