Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,326 through 41,340 (of 59,069 total)

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
RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

mike brockington (8/5/2009)
Heh... that's why I'm able to make a living.
And how many times to you get brought in to sort out a system that had been 'upgraded' or...
--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:20 pm

#1071005
RE: Are the posted questions getting worse?

WayneS (10/26/2009)
That's a bummer Jeff... but is the new job going good?
Thanks for asking, Wayne. The new job is going great... except that I can't get time...
--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 8:44 pm

#1071002
RE: Are the posted questions getting worse?

RBarryYoung (10/26/2009)
Bob Hovious 24601 (10/25/2009)
Good to hear, Jack 🙂 🙂 🙂
Barry, congratulations on getting my question right on the first try. I predict it will be very profitable for...
--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 8:40 pm

#1071001

Viewing 15 posts - 41,326 through 41,340 (of 59,069 total)