Oh sergiy - don't be afraid of little ol' CLR...It ain't going to bite you....Show me one feature

MS introduced without a memory leak in its "first attempt":)

"Just another arrow...

Now - the fun begins:)... Did I mention I love the cage-match format for testing? hehe.....

All right - you want your 2 seconds back....I got them. I'll...

Max Yasnytskyy (10/18/2007)

Because of the way .net garbage collector works and intensive processing of strings, which are as we all know immutable and every modification of the string essentially creates...

Jeff Moden (10/18/2007)

---

Ok... just ran Matt's code against the million row table... Ladies and Gentlemen, we have a tie! :w00t: Matt's function took the same amount of time as...

sqlServer had 256MB in use at all times. Didn't ask for more (100MB stayed "free" the whole time).

APOLOGIES.....

There was STILL one flaw...was trying to fix some of the f****ing formatting, and I blew out a 5 and replaced it with a 7. Had been right in...

ACtually - I'm way ahead of ya. That last response felt a bit like a cop-out, so I went and built my own "big table. For lack of...

I don't have a HUGE database on hand with relevant data, but on 50K records...maybe a second.

You could also look at dropping the fill factor somewhat on the indexes that get very fragmented. That's what that's for (allowing for some internal rearranging without a page split).

So - it's not a bug - it's a feature?

(couldn't resist)

I'm assuming you've already figured out that the files need to have the same internal architecture (same delimiters, columns names, etc....) I'm also going to assume that you've created...

funny... I vaguely remember seeing something about a CASE statement somewhere before in this thread....

I mean - right! I agree with Jeff! 😀

I don't know - a coup d'etat sounds exciting:w00t:

Structure the new organization as a pure technocracy. Possible bylines/mottos:

- "Two DBA enter - one DBA leave" (as rendered by...

Try not to double-post.

http://www.sqlservercentral.com/Forums/Topic412429-338-1.aspx

There's a way, but not quite what you'd expect. You define the function as you normally would, with a default value set on the optional param's, but when you...