Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,801 through 43,815 (of 59,101 total)

RE: indian authors for sql server book

Paul White (5/12/2009)
Jeff Moden (5/12/2009)
It pays to be polite and clear to people in all walks of life whether you expect to gain knowledge from them or not.
Oh zark off...
--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 12, 2009 at 6:41 pm

#993365
RE: Performance issue with tally solution

UMG Developer (5/12/2009)
Jeff Moden (5/11/2009)
Once you recognize the "pattern", you don't need all the ancillary conditional data moves and deletes. The "pattern" is that if it's NOT a continuation...
--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 12, 2009 at 6:28 pm

#993361
RE: Performance issue with tally solution

David Burrows (5/12/2009)
Nice one Jeff 😎
Thanks, David. I didn't understand the problem until I saw the test data (funny how important that is :-D). Thought we could do...
--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 12, 2009 at 6:25 pm

#993360
RE: Performance issue with tally solution

UMG Developer (5/12/2009)
Jeff,
Now you've essentially got my roll it up and then split it method that takes ~2 minutes for the roll up, and ~16 minutes for the split. I...
--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 12, 2009 at 6:18 pm

#993359
RE: indian authors for sql server book

Vinoo (5/12/2009)
anu1krishna (5/11/2009)
this is not the ans of my question please dont ask question if u dont wann to give ans.//
Please understand that this forum has people who are extreme...
--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 12, 2009 at 6:33 am

#992800
RE: Performance issue with tally solution

Once you recognize the "pattern", you don't need all the ancillary conditional data moves and deletes. The "pattern" is that if it's NOT a continuation line, add a leading...
--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 11:14 pm

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

peter.lopez (5/11/2009)
Analysis Paralysis. You assume that you have to go through 1000 resume. Statistically you dont, select 100 top ones and another 30 over the next 900 at random. Invariably...
--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 9:39 pm

#992614
RE: indian authors for sql server book

anu1krishna (5/11/2009)
hi all
can anybody provide me the name of indian writers for sql server beginners book which i shuld buy to increase my knoledge
anu1krishna (5/11/2009)
this is not the ans of...
--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:46 pm

#992602
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

Viewing 15 posts - 43,801 through 43,815 (of 59,101 total)