Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,006 through 37,020 (of 59,098 total)

RE: Are the posted questions getting worse?

Gianluca Sartori (9/3/2010)
Lynn Pettis (9/2/2010)
IIRC, it is actually a myth that Oracle runs better with loops and cursors. Perhaps I'll have the opportunity to verify that well written set-based...
--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 3, 2010 at 10:57 pm

#1216503
RE: Are the posted questions getting worse?

GSquared (9/1/2010)
Here's an interesting one. This is the list of skills someone wants for their "DBA":
Must have advanced proficiency and extensive knowledge of web development and design technologies, and...
--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 3, 2010 at 10:46 pm

#1216502
RE: Are the posted questions getting worse?

Alvin Ramard (9/1/2010)
Roy Ernest (9/1/2010)
When are these recruiters going to contact me? 🙁 No one ever contacts me... My LinkedIn is already beefed up. Cant beef it up anymore. 😀
Too...
--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 3, 2010 at 10:39 pm

#1216501
RE: Are the posted questions getting worse?

Brandie Tarvin (9/1/2010)
Grant's comment leads me to this question: What do the rest of you do if you get a call, or linked in mail, but aren't looking for a...
--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 3, 2010 at 10:24 pm

#1216500
RE: Are the posted questions getting worse?

Roy Ernest (9/1/2010)
Gail is on the verge of hitting 20K. Wow. I am at 2300. It will take me a decade or more to get to that figure.
@jeff :...
--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 3, 2010 at 10:19 pm

#1216499
RE: Are the posted questions getting worse?

Alvin Ramard (8/31/2010)
CirquedeSQLeil (8/31/2010)
how about a countdown for 18000 now?
24 more :hehe:
Ok, time to turn off the email notifications.
Heh... auto-delete rule temporarily instantiated. 😉
--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 3, 2010 at 10:14 pm

#1216497
RE: Are the posted questions getting worse?

LutzM (8/31/2010)
Jan Van der Eecken (8/31/2010)
Various curries, beer and red wine on this side. And no, I'm not a DBA either, so my choice of energy providing food/drink sources may...
--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 3, 2010 at 10:11 pm

#1216495
RE: Are the posted questions getting worse?

Ray K (8/31/2010)
Steve Jones - Editor (8/31/2010)
I'm not surprised, I think we have more and more hybrid people.
You're right. I run on both gasoline and electricity.
:hehe:
I'm older... I run...
--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 3, 2010 at 10:08 pm

#1216494
RE: Are the posted questions getting worse?

David Burrows (8/31/2010)
Jeff Moden (8/31/2010)
... (they had to call me something) ...
Do you want us to suggest something 😛
Nope... I'm getting plenty of suggestions on the Running Total discussion, again....
--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 3, 2010 at 10:05 pm

#1216493
RE: Are the posted questions getting worse?

Brandie Tarvin (8/31/2010)
Alvin Ramard (8/31/2010)
GilaMonster (8/31/2010)
Not a DBA, never been a DBA. Should I leave now?
...
Just kidding folks. We ALL need to stay! We can all contribute, and...
--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 3, 2010 at 10:04 pm

#1216492
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/31/2010)
Paul White NZ (8/31/2010)
Good job on the scheduling, Steve. Very neat.
Thanks.
Look for Mr. White's optimizer series over the next few weeks.
The series will be...
--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 3, 2010 at 9:56 pm

#1216490
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Paul White NZ (9/3/2010)
Jeff Moden (9/3/2010)
If a SEEK occurs, you could get an out of order update and that's why I didn't recommend INDEX(1). INDEX(0) forces the clustered index...
--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 3, 2010 at 9:34 pm

#1216486
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

WayneS has a link to your Cross Tabs and Pivots article on his signature line(thank you WayneS 🙂
Thank you for the reference and for helping others, as well, Wayne.
--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 3, 2010 at 8:42 pm

#1216481
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

le_billy (9/1/2010)
Jeff,
I was having difficult time understanding how Pivot work, so I was searching the SSC forum and found thousand and thousand of posts which make my head spin(Now learn...
--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 3, 2010 at 8:37 pm

#1216480
RE: inventory system

If you spend a little time reading it, you find the following quite interesting.
http://ask.sqlservercentral.com/questions/826/the-fifo-stock-inventory-sql-problem
--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 3, 2010 at 2:54 pm

#1216426

Viewing 15 posts - 37,006 through 37,020 (of 59,098 total)