Viewing 15 posts - 54,091 through 54,105 (of 59,068 total)
Matt is correct... he's beat the snare right off that drum... and guess what? He's right! Matt and I have done a huge amout of testing and using...
November 15, 2007 at 5:24 pm
Took a while to get the code realigned correctly after the copy/paste operation
Matt,
Reformatting code that you've copied from those "Code" windows is actually pretty easy (although I wish they'd just...
November 15, 2007 at 3:16 pm
Actually, you can get to the precise post Matt is talking about by clicking on the following... not need to hunt pages...
http://www.sqlservercentral.com/Forums/Topic419472-65-2.aspx#bm422799
November 15, 2007 at 2:59 pm
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
Viewing 15 posts - 54,091 through 54,105 (of 59,068 total)