Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,356 through 41,370 (of 59,102 total)

RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

Heh... if the infrastructure is setup correctly, the correct answer is.... none.... the servers will take care of themselves and on the rare occasion that they can't, they'll call someone...
--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)

October 28, 2009 at 8:28 pm

#1072189
RE: 4 table join - easy one for you guys

"It Depends". Which table has ALL Loan_ID's and what do you want to actually return? There may be the need for an "OUTER" join in there but, like...
--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)

October 28, 2009 at 8:09 pm

#1072186
RE: Providing 2 numbers as hour numbers and third input number as minute and getting result in third number's difference from start hour to end hour

slange-862761 (10/28/2009)
This sounds a lot like a school project. Why in the world would you need something like this otherwise? That being what it is this was a fun challenge!!
Here...
--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)

October 28, 2009 at 8:02 pm

#1072185
RE: Remove entire word from field

Take a gander at the REPLACE function in Books Online... that should do the trick.
--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)

October 28, 2009 at 7:57 pm

#1072183
RE: Would you be concerned??

Heh... liberally apply pork chop grease to the lens. :-P;-)
Just kidding... don't touch the camera yourself. I agree with the others... contact the folks at the day care...
--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)

October 28, 2009 at 7:55 pm

#1072182
RE: Are the posted questions getting worse?

Nope... no pork chops on UNPIVOT. It' a tried and true method... I just wish they'd make PIVOT and UNPIVOT a little more automatic like they did with PIVOT...
--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)

October 27, 2009 at 6:50 pm

#1071526
RE: The Value of Experience

Lynn Pettis (10/27/2009)
I have to agree that experience is extremely helpful. You learn about things that you may not have known about otherwise. I have experience in computer...
--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)

October 27, 2009 at 3:52 pm

#1071489
RE: Stored Procedures Reconsidered

Thanks for the reply, Ben. Good stuff.
The problem with true "Ram Disks" in the future is that they do nothing to help the "pipe". You still have 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)

October 27, 2009 at 7:14 am

#1071178
RE: Need help to write a loop store procedure

Krasavita (10/26/2009)
Thank you, but this code I run takes to long and Begin Tran takes much faster,do you know why?
I suppose it's possible that the optimizer is locking the whole...
--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)

October 27, 2009 at 7:04 am

#1071172
RE: Any Cons to long column names.

Heh... sounds like VBS...
--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)

October 27, 2009 at 7:00 am

#1071169
RE: Are the posted questions getting worse?

Bob Hovious 24601 (10/26/2009)
Really sorry to hear that, Jeff.
(Say... are you going to finish the rest of those pork chops..... ??)
Now THAT's funny! 😛 Thanks...
--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)

October 27, 2009 at 6:56 am

#1071164
RE: Are the posted questions getting worse?

Grant Fritchey (10/27/2009)
Jeff Moden (10/26/2009)
Crap... I can say "crap" on this post, right? Crap, crap, crap... it's happened again same as last year and for the same reason. ...
--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)

October 27, 2009 at 6:55 am

#1071163
RE: Stored Procedures Reconsidered

braindea-754908 (10/23/2009)
Glad I came upon this post. I have long suspected that there was someone else who looked at this as I do. I've been programatically constructing database...
--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)

October 26, 2009 at 10:24 pm

#1071016
RE: Stored Procedures Reconsidered

DiverKas (7/31/2008)
DBA - Database Administrator. Nothing in that job description even comes close to what an architect does.
Look at the article you cited again... the very first...
--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)

October 26, 2009 at 9:53 pm

#1071011
RE: The Value of Experience

Robert.Smith-1001156 (10/26/2009)
I agree. DBAs need to get out more.
I once had a DBA ask me if I'd mind phoning a client for him because he "didn't like talking 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)

October 26, 2009 at 9:32 pm

#1071007

Viewing 15 posts - 41,356 through 41,370 (of 59,102 total)