Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Parse Info Out of FileName Expand / Collapse
Author
Message
Posted Thursday, February 27, 2014 5:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:41 PM
Points: 3,960, Visits: 2,970
Jeff Moden (2/26/2014)
Ed Wagner (2/26/2014)
... and it does 1M rows in about 12 seconds.


Heh... damn. I must be gettin' old and starting to slip.

If you keep the underscores and use DelimitedSplit8K, it does 1M in about 8 seconds, but the regular expression has never been known to be a speed demon in any language. Nonetheless, for what it does, I'd say that he OP is not going to have 1M incoming files in the file system without running into a host of other problems.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1545799
Posted Thursday, February 27, 2014 6:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
I guess "keeping the underscores" would be a prob lem for the OP, though. His original format had no underscores.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1545842
Posted Thursday, February 27, 2014 6:39 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:41 PM
Points: 3,960, Visits: 2,970
Jeff Moden (2/27/2014)
I guess "keeping the underscores" would be a prob lem for the OP, though. His original format had no underscores.

DOH!!! You're absolutely right. Now my question is where I got the underscores in the first place. Now I must be getting old...starting to see things.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1545848
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse