Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,176 through 44,190 (of 59,097 total)

RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Andy DBA (4/15/2009)
I apologize if this is somewhat off topic and there's probably tons of articles on it already, but here is a word to the wise on performance testing....
--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)

April 15, 2009 at 8:00 pm

#978558
RE: Are the posted questions getting worse?

Bob Hovious (4/15/2009)
Oh good. People keep using that word and I get paranoid.
Heh... isn't that an oxymoron in itself? 😛
I keep telling folks, you don't ever want...
--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)

April 15, 2009 at 4:35 pm

#978501
RE: Are the posted questions getting worse?

Bruce W Cassidy (4/15/2009)
[font="Verdana"]Warning! Mini rant!
I'm reading an article (it's work related, okay?) and I run across this paragraph:
"The first and most obvious reason is that the DW appliance...
--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)

April 15, 2009 at 4:33 pm

#978499
RE: Are the posted questions getting worse?

Lynn Pettis (4/15/2009)
Jeffrey Williams (4/15/2009)
Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response...
--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)

April 15, 2009 at 4:30 pm

#978498
RE: The T-SQL Paradigm

andrew gothard (4/15/2009)
Jeff Moden (4/14/2009)
Jim Russell (4/14/2009)
Charles Kincaid (4/13/2009)
Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical...
--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)

April 15, 2009 at 4:20 pm

#978489
RE: How to convert INTEGER to TIME

My bad... looking back on this, I see where you took his suggestion early on. Sorry and thanks for the feedback.
--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)

April 15, 2009 at 10:34 am

#978235
RE: How to convert INTEGER to TIME

So... did any of this solve your problem or not?
--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)

April 15, 2009 at 9:36 am

#978181
RE: Performance issue with tally solution

Lynn Pettis (4/14/2009)
Everyone on this thread deserves a round of applause (or maybe the theme music from the end of the original Star Wars, unfortunately, I don't have it!).
Lemme show...
--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)

April 14, 2009 at 8:37 pm

#977809
RE: Performance issue with tally solution

RBarryYoung (4/14/2009)
Jeff Moden (4/14/2009)... this is going to be more fun that trying to catch a vole while wearing silk gloves.
You have some weird hobbies, dude.
😛
BWAA-HAAA!!!! At least I don't...
--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)

April 14, 2009 at 8:30 pm

#977805
RE: Performance issue with tally solution

I don't know what anyone else thinks, but this is a freakin' awesome thread. I don't believe such a huge collection of talent and code has ever come together...
--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)

April 14, 2009 at 7:51 pm

#977795
RE: Performance issue with tally solution

Florian Reischl (4/14/2009)
Hi everybody
Sorry for my late answer but I had a busy day at work...
Thank you for all your investigations and your time!!!
I've not been lazy. I did many...
--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)

April 14, 2009 at 7:37 pm

#977793
RE: Cursors Be Gone!

Hi Wayne,
I'm not sure what you mean by "how fast you did the coding". Lots of folks posted and I was just one of them... In fact, 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)

April 14, 2009 at 7:24 pm

#977790
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Wedge78 (4/14/2009)
Hi All
I agree that you can run into problems when using cursors without thought
However I have an instance where I have to gather information from a 3.2 billion row...
--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)

April 14, 2009 at 3:54 pm

#977730
RE: The T-SQL Paradigm

Jim Russell (4/14/2009)
Charles Kincaid (4/13/2009)
Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical sensors.
The optical paper...
--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)

April 14, 2009 at 3:37 pm

#977719
RE: You have 1,000,000 records in your customers table....

Steve Jones - Editor (4/14/2009)
Part of wording the questions is that I have to limit the scope. One way to do that is exaggerate a bit to get you to...
--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)

April 14, 2009 at 10:59 am

#977437

Viewing 15 posts - 44,176 through 44,190 (of 59,097 total)