Dividing a list of filenames into roughly equal batch sizes in KB

Question

Dividing a list of filenames into roughly equal batch sizes in KB

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 1

Sean Lange (2/29/2012)
I too suspected this wasn't going to end up set based because of the nature of the whole thing. I sort of eluded to that in my post that the code I did was reasonably close on the pretty flat example data. I had a feeling that on real data it wouldn't be any better than what the OP was doing originally.

Oh, no need for any apology or humility for any reason here, ol' friend. This type of problem is a real pickle. I also very much appreciated your thoughtful warnings/disclaimers because they helped me avoid a couple of pitfalls in my own poor attempts to find a set-based solution for this problem. Heh... Looking at it another way, there are more than 1.4 million members on this fine forum and you were the first of only two to take a shot at this. You should be thanked for trying to solve this problem.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 2

Elliott Whitlow (3/1/2012)
You know I have a different path and think it was mentioned above. Why do we care what process handles a particular file, just that they all get handled and as fast as possible.

Exactly. The only reason why I included the FEL in the ORDER BY of the TOP 1 sort is because humans (heh... or at least I do) like to see things in a nice logical order when looking back to see "wha' happened???"

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Paul Golabowski SSChasing Mays Points: 646 More actions · Answer 3

I realize in scrolling up that it looks like I was only thanking Jeff. That wasn't my intent at all. Sean, thanks go to you too for stepping in with a solution first.

And also to you, Elliott.

So again, thanks to all for chipping in on this!

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 4

Gah... My apologies for a poor choice of words. :blush: My "you should be thanked" comment wasn't directed you at all. I can't speak for Sean but I took your original bit of thanks to include everyone up to that point including Sean. My comment was just meant to give Sean some props for his fine effort and not to imply any shortcoming on your part.

Darned nice of you to come back with what you did, though.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

I agree Jeff. I certainly wasn't concerned at all about receiving thanks. I also just read it as thanks to all who posted, which included me. 😀 Sheesh pretty soon we are going be thanking each other for thanking each other.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

Elliott Whitlow

SSC Guru

Points: 102402

March 2, 2012 at 8:09 am

#1454197

Mutual Admiration Society?

CEWII

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 7

Elliott Whitlow (3/2/2012)
Mutual Admiration Society?
CEWII

BWAA-HAAA!!! Well thank you Elliott. You are DA MAN! :-):-D:-P

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 8

Why thank you.. Always looking for a little levity, the last two weeks for me have been hell..

CEWII