Viewing 15 posts - 58,231 through 58,245 (of 59,048 total)
Yep... I'd test it... "it depends" and the age old adage of "one measurement is worth a thousand speculations" still holds true. It's especially true in the world of multi-processors......
May 5, 2006 at 7:05 am
The following is wrong because it leaves out one entire second of the day...
BETWEEN '2006-05-01 00:00:00.000' AND '2006-05-01 23:59:59.000'
...depending on the source of the data, there could be thousands...
May 4, 2006 at 10:12 pm
The reason I ask is because I DO have a Clustered Primary Key on the N column of my Tally table and here's the results I got from the 3...
May 4, 2006 at 9:00 pm
Kenneth,
Does your Tally table have a Primary Key?
May 4, 2006 at 8:09 pm
Jeff,
Great use of a Tally/Numbers table... is more than twice as fast as the WHILE LOOP method...
Shifting gears.... in your code, change this...
select @address = '1300 teseter 234'
...to this...
select @address...
May 3, 2006 at 9:05 pm
Nope, no experience with GPS phone providers here, either. But what you have planned not only sounds very feasible, it sounds like a hell of a lot of fun, too! ...
May 3, 2006 at 7:10 am
Here's the example xp_CmdShell code I will sometimes use... note that I always include the hardcoded DOS command DIR and I always include the path in double quotes to help...
May 3, 2006 at 7:05 am
Not sure exactly how you would do it in DTS but I'm thinking that if you built some error logic around the fact that the files are empty and that...
May 3, 2006 at 6:56 am
Another country hear from! Also, very neat, David. Interesting use of SIGN as a "lump detector".
Juliano... has one of these 3 solutions provided you with the answer you needed? They...
May 3, 2006 at 6:50 am
... except to continue
Shows how much I use loops and I didn't read the code well enough.. Thanks for the clarification...
May 3, 2006 at 6:38 am
VERY cool... I've seen a lot of hierarchical code in my time... this is great... First time I've seen anyone make good use of the CONTINUE statement without them getting...
May 3, 2006 at 2:03 am
Heh... I sure do appreciate what that's all about... been there and done that... just not with a cursor so I have no idea if a cursor can be created...
May 3, 2006 at 1:48 am
Why do you need a cursor for this? If you converted the cursor to set based code, the dynamic SQL would work just fine...
May 2, 2006 at 9:25 pm
Not a bad function but it takes more than 4 minutes to execute on a mere million rows where each row contains a six word value...
The following function, butt ugly...
May 2, 2006 at 8:21 pm
As Ryan pointed out... had a little bug in my code and repaired it. Managed to condense it a bit, too. Still takes a very pigish 16 mintues to run...
April 26, 2006 at 11:03 pm
Viewing 15 posts - 58,231 through 58,245 (of 59,048 total)