Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,496 through 54,510 (of 59,098 total)

RE: how to remove numbers from strings?

Heh... jury is still out on 2 times... it's starting to look a lot like the hardware or the installation may also make a huge difference. Davids times came...
--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 21, 2007 at 1:49 pm

#743964
RE: how to remove numbers from strings?

Why would you think that that would remain unquestioned, when it was simply a repeat of the personal attack, that again, has no place in this forum?
Sorry, David, I sure...
--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 21, 2007 at 1:37 pm

#743961
RE: how to remove numbers from strings?

OMG... what a complete rookie copy'n'paste mistake on my part... :blush: I'm so sorry...
Lowell, here's the code, one more time... would you and David please do the honors? ...
--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 21, 2007 at 1:23 pm

#743960
RE: Saving binay data to disk via TSQL???

Heh... I actually haven't tried it because I won't allow folks to store images in our databases... but I don't see why it wouldn't work... it's just another form of...
--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 21, 2007 at 12:45 pm

#743954
RE: SQL Server Periodically Hangs - Troubleshooting Suggestions?

Hi Dave,
Man, I feel for ya... been there my own self...
Just curious, though... even if the code were just "the straw that broke the camel's back", if it has known...
--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 21, 2007 at 12:43 pm

#743953
RE: simplifying code

Heh... that's what "embedded comments" are for 🙂 But, I understand...
--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 21, 2007 at 12:35 pm

#743951
RE: how to remove numbers from strings?

I'd add things like PIVOT
Cool... Once we figure out what's meant my "missing subtrahend" in the previous code and retest, I'd love to do a test on the 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)

October 21, 2007 at 12:32 pm

#743950
RE: how to remove numbers from strings?

Look at the code again, but this time play a game of "Find the missing subtrahend" while doing so.
Thanks for the test, David...
Haven't "studied" the code... what do...
--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 21, 2007 at 12:28 pm

#743949
RE: Preventing Page Locks

Just to support what's already been stated... I agree... "too much" blocking is normally caused by long winded transactions or other code that simply takes too long... indexes may help,...
--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 21, 2007 at 11:26 am

#743944
RE: simplifying code

No, no! The Tally table in this code was just to have a table to demonstrate from... I copied it from the previous post that MrPoleCat posted... (heh, you...
--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 21, 2007 at 11:01 am

#743943
RE: how to remove numbers from strings?

Outstanding! And on a Sunday, no less! You ARE the MAN, Lowell!
I don't know about anyone else, but while a lousy 9 second difference on a lousy million...
--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 21, 2007 at 10:46 am

#743942
RE: Adding workdays

Sergiy (10/20/2007)
Probably you never got into this task seriously.
Yeah... absolutely correct... and I guess I need to learn how to use a date table for these types of things with...
--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 21, 2007 at 9:22 am

#743941
RE: how to remove numbers from strings?

David McFarland (10/20/2007)
Now I'm dying to ask, and please don't take it personal. What does this have to do with this thread (or even that other thread, if that's 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)

October 21, 2007 at 8:50 am

#743939
RE: how to remove numbers from strings?

Lowell (10/21/2007)
ok here's some performance numbers from my machine, which has both SQL2000 and SQL 2005:
Jeff's inner join example took ...
--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 21, 2007 at 8:24 am

#743937
RE: how to remove numbers from strings?

So what?
Heh... HOT DAMN! One performance test coming right up... somebody run the following in 2k5 'cause I still don't have it yet... I removed the ORDER...
--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 20, 2007 at 8:14 pm

#743899

Viewing 15 posts - 54,496 through 54,510 (of 59,098 total)