Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,511 through 36,525 (of 59,067 total)

RE: Are the posted questions getting worse?

Kit G (9/30/2010)
WayneS (9/30/2010)
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:
If he's in...
--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)

September 30, 2010 at 9:02 pm

#1230002
RE: Are the posted questions getting worse?

Tom.Thomson (9/30/2010)
Jeff Moden (9/29/2010)
Heh... nah... there are other places other than Alaska where such a thing occurs. 😉
East side of Michigan - anywhere between Detroit and Port Huron? That's...
--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)

September 30, 2010 at 9:01 pm

#1230001
RE: Are the posted questions getting worse?

Kit G (9/30/2010)
WayneS (9/30/2010)
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:
If he's in...
--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)

September 30, 2010 at 8:59 pm

#1230000
RE: Are the posted questions getting worse?

Grant Fritchey (9/29/2010)
Jeff Moden (9/29/2010)
CirquedeSQLeil (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses...
--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)

September 30, 2010 at 8:47 pm

#1229998
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/29/2010)
Jeff Moden (9/29/2010)
Steve Jones - Editor (9/29/2010)
Speaking of stirring, new rice cooker coming today. Excited to be able to walk away and let it cook so...
--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)

September 30, 2010 at 8:44 pm

#1229997
RE: Are the posted questions getting worse?

Roy Ernest (9/30/2010)
Damn... That is arrogant and insulting. He should not be talking like this. Even if he knows it all.
Add to that... he actually doesn't know it all. 😉
--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)

September 30, 2010 at 8:42 pm

#1229996
RE: Are the posted questions getting worse?

Jack Corbett (9/30/2010)
Jeff Moden (9/30/2010)
Jack Corbett (9/30/2010)
Update on the "maverick". Just had discussion with my boss about it. I've been asked to write up an email about what...
--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)

September 30, 2010 at 8:03 pm

#1229991
RE: Are the posted questions getting worse?

WayneS (9/30/2010)
BTW, what do you burn your wood in? I use the 200-CSS.
Flux capacitor with a hampster poo kicker. 😀
--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)

September 30, 2010 at 7:56 pm

#1229990
RE: Are the posted questions getting worse?

Jack Corbett (9/30/2010)
Update on the "maverick". Just had discussion with my boss about it. I've been asked to write up an email about what has been going on...
--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)

September 30, 2010 at 9:09 am

#1229688
RE: Problem with CURSOR

luissantos (9/29/2010)
Hello comunity
I have a problem with this following cursor, because my column SALDO (RunningTotal) dont reset when @nrcli and @vendedor (nrcli is customer number and @vendedor is Sales member...
--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)

September 29, 2010 at 6:59 pm

#1229426
RE: how to raise alert on table row count

mickeytech2000 (9/29/2010)
I need to raise an alert when a table row count exceeds a certain value. Please help me and let me know how to do that. Thank you very...
--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)

September 29, 2010 at 6:54 pm

#1229425
RE: generate rows based on integer

Oh yeah... almost forgot... make sure that "N" in the Tally table is bigger than the largest value of column 5 or at least do a test to see because...
--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)

September 29, 2010 at 6:50 pm

#1229424
RE: generate rows based on integer

This should handle 5 million rows in just a couple of minutes...
--===== Setup a test table (THIS IS NOT A PART OF THE SOLUTION)
SELECT TOP (1000)
...
--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)

September 29, 2010 at 6:39 pm

#1229422
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/29/2010)
Speaking of stirring, new rice cooker coming today. Excited to be able to walk away and let it cook so I can only worry about stirring...
--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)

September 29, 2010 at 5:56 pm

#1229416
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as "not invented...
--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)

September 29, 2010 at 5:48 pm

#1229414

Viewing 15 posts - 36,511 through 36,525 (of 59,067 total)