Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,771 through 43,785 (of 59,063 total)

RE: Performance issue with tally solution

UMG Developer (5/11/2009)
Jeff Moden (5/11/2009)
UMG Developer (5/11/2009)
1 Line1|Line2|Line3
Heh... "Tab or whatever to separate fields"...
Please be very specific with no "whatevers"... What is the actual format of the lines/comments/other fields...
--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)

May 11, 2009 at 8:17 pm

#992596
RE: Performance issue with tally solution

Florian Reischl (5/11/2009)
Hi Paul
I know this sound's strange but all my tests showed, that the set-based solutions using a Tally table run into problems with huge text and large result...
--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)

May 11, 2009 at 8:12 pm

#992594
RE: Improving data import performance - More RAM ?

RBarryYoung (5/11/2009)
Hey, thanks for the plug, Jeff!
Absolutely no problem, ol' friend. I love that series (can't wait for the next part) and the tremendous responses you got from the...
--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)

May 11, 2009 at 8:02 pm

#992593
RE: Improving data import performance - More RAM ?

RBarryYoung (5/11/2009)
Heh, you're killing me here, Jeff. I never actually removed the loop. Yeah, I know, that's a first for me, but I was just trying to get...
--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)

May 11, 2009 at 7:54 pm

#992591
RE: Improving data import performance - More RAM ?

Haven't tested it, but here's how I'd convert the code... gets rid of one of the Temp Tables, a couple of variables, and the loop. It's not so important...
--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)

May 11, 2009 at 7:51 pm

#992589
RE: Improving data import performance - More RAM ?

ifila (5/7/2009)
NO.....they are resumes and people vary the location of content.
Thanks
BWAA-HAAA! According to what I see in Barry's fine code, they were, in fact, all the same "format".
Glad you...
--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)

May 11, 2009 at 6:12 pm

#992579
RE: Performance issue with tally solution

UMG Developer (5/11/2009)
1 Line1|Line2|Line3
Heh... "Tab or whatever to separate fields"...
Please be very specific with no "whatevers"... What is the actual format of the lines/comments/other fields and what determines the...
--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)

May 11, 2009 at 5:56 pm

#992575
RE: Where Do You Search for DBA Jobs?

nicholasblethyn (5/11/2009)
Serendipity.
The recruiter's best friend has just been launched ...
http://www.telegraph.co.uk/finance/newsbysector/retailandconsumer/5297646/Trevor-Bish-Joness-click-and-mix-approach-to-recruitment.html
Heh... if the automatch requirements that people end up putting into the system are anything like the job requirements I've seen...
--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)

May 11, 2009 at 6:09 am

#992024
RE: UPDATE column with auto number depending on field value ?!

Oh yeah... there's one other thing. You were told a long time ago that you simply can't guarantee the correct order for this type of update unless you have...
--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)

May 11, 2009 at 5:56 am

#992020
RE: UPDATE column with auto number depending on field value ?!

m.berggren (5/11/2009)
Hi,
This works perfekt. I´m thinking of maybe making this more dynamic in some way. Let´s say you don´t know how many "cat" youré having. Let´s say you have for...
--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)

May 11, 2009 at 5:47 am

#992016
RE: Performance issue with tally solution

UMG Developer (5/11/2009)
I'm not a bulk import expert because pretty much all of my data starts in a DB, I took a quick look at BCP, and it didn't seem...
--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)

May 11, 2009 at 5:39 am

#992013
RE: Matrix multiplication without cursors?

In fact... here's a couple of other views concerning world wide browser usage...
http://www.thecounter.com/stats/2009/March/browser.php
http://www.upsdell.com/BrowserNews/stat.htm
http://en.wikipedia.org/wiki/Usage_share_of_web_browsers#Present_to_1999
--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)

May 10, 2009 at 7:48 pm

#991876
RE: Performance issue with tally solution

Phil Factor (5/10/2009)
Jeff Moden
Any word on this, Phil? Copying code from the code windows makes some really ugly stuff with extra line breaks, no indentation, and all those nasty things...
--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)

May 10, 2009 at 7:20 pm

#991874
RE: Matrix multiplication without cursors?

Heh... "Must look eye". That's just for the people that hit the W3Schools website... not what the rest of the world is
doing. Even W3Schools acknowledges that when they included...
--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)

May 10, 2009 at 7:01 pm

#991872
RE: Performance issue with tally solution

UMG Developer (5/10/2009)
I've never heard the phrase to "pork chop" someone what does it mean?
There's a pretty long story behind it, but it basically means taking the person responsible for...
--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)

May 10, 2009 at 6:49 pm

#991871

Viewing 15 posts - 43,771 through 43,785 (of 59,063 total)