Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,756 through 43,770 (of 59,063 total)

RE: Are the posted questions getting worse?

I'm finally going to break down and buy a laptop (computer, that is 😛 ). I'd prefer a 17" display but will go with a decent 15" display. ...
--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 9:41 pm

#993410
RE: Are the posted questions getting worse?

Heh... I finally found a video to use at the beginning of any seminars I may have the good fortune to speak at...
http://www.youtube.com/watch?v=amICZ1aVaCg
--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 9:27 pm

#993407
RE: Are the posted questions getting worse?

Alvin Ramard (5/12/2009)
Jeff Moden (5/12/2009)
Alvin Ramard (5/12/2009)
How many point will I get if I post that video of Bob playing the banjo and signing his song?
😀
Minus 50 😀
Even if it...
--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 9:04 pm

#993400
RE: indian authors for sql server book

Heh... get any on ya, Barry? 😛
--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 9:00 pm

#993399
RE: Are the posted questions getting worse?

john.arnott (5/12/2009)
It's an interesting series of posts from the latest pork chop target.
What's the link for that one, John?
--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 8:34 pm

#993392
RE: Are the posted questions getting worse?

Alvin Ramard (5/12/2009)
How many point will I get if I post that video of Bob playing the banjo and signing his song?
😀
Minus 50 😀
--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 8:31 pm

#993391
RE: indian authors for sql server book

Paul White (5/12/2009)
Jeff Moden (5/12/2009)
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...
--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 7:14 pm

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

Viewing 15 posts - 43,756 through 43,770 (of 59,063 total)