Viewing 15 posts - 2,791 through 2,805 (of 7,636 total)
Paul White (4/19/2009)
That's very clever - I hadn't thought of that. Points to you!
Without being churlish though, I would argue that multi-process is very different from multi-thread:
* Processes are...
April 19, 2009 at 9:42 pm
Paul White (4/19/2009)
By the way, only multi-threaded examples will win the prize - multi-process is not the same at all!
Hah. Unfortunately, I am old enough to know that there...
April 19, 2009 at 8:28 pm
Florian Reischl (4/19/2009)
The problem is the string builder. It takes to much overhead inside.
I wouldn't use StringBuilder for this, you want to fill an array of characters or int16's and...
April 19, 2009 at 7:32 pm
Florian Reischl (4/19/2009)Barry also showed a parser which performed much better than the TSQL solution in another thread some weeks ago. Sorry, I don't remember the topic.
It's a transducer actually...
April 19, 2009 at 7:23 pm
Bruce W Cassidy (4/19/2009)
Use an array of 256 2-character strings with the hexadecimal encoding for each byte. So...
April 19, 2009 at 6:57 pm
Paul White (4/19/2009)One more example from recent times: there was a need to check the network status of 2,500 remote MSDE instances, and retrieve the lastest record_id on some table...
April 19, 2009 at 5:57 pm
I have to admit, I found that very confusing.
April 19, 2009 at 5:32 pm
Technically, its a constant scan. They're very fast. 🙂
April 19, 2009 at 5:21 pm
Gidday, Bruce!
April 19, 2009 at 5:16 pm
Here[/url]'s the first article in an on-going series on that very subject (by me). The discussion attached to it gets pretty deeply into it also.
April 19, 2009 at 12:35 pm
Actually for something this small you don't even need that. This should work:
Select m.Month
, c.client
, Coalesce(t.sell, 0) as Sell
From (Select 1 as Month
Union All...
April 19, 2009 at 12:25 pm
Jeff Moden (4/19/2009)
I may have to fire up VB.net or learn "C#" just to make some of those things come true.
Well, if you won't run anyone else's compiled code, what...
April 19, 2009 at 11:48 am
If you get the chance Phil, you might want to suggest to someone that they could include some kind of installation instructions somewhere...? The ReadMe in the ZIP file...
April 19, 2009 at 11:20 am
Still a little puzzled. I thought that you only got row-versioning if you turned Snapshots or RCSI on?
April 19, 2009 at 11:05 am
Viewing 15 posts - 2,791 through 2,805 (of 7,636 total)