Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,481 through 54,495 (of 59,098 total)

RE: SQL Server Periodically Hangs - Troubleshooting Suggestions?

Heh, yep... I've been there as well... puts the DBA between a rock and a hard spot.
I guess all you can do is wait, then. When it gets bad...
--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 22, 2007 at 7:08 am

#744127
RE: how to remove numbers from strings?

HEH!! Now, THAT's entertainment 😀
--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 22, 2007 at 7:00 am

#744121
RE: Looking for a really good Database Modeling/Design course

Ah... thanks and sorry... didn't know your background and I took the really conservative route. I'm also sorry that I don't have any recommendations. I've been through 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)

October 22, 2007 at 6:59 am

#744118
RE: Adding workdays

Michael Meierruth (10/22/2007)
How to you select/copy/paste the sample code in the gray background areas?
When I do this I don't get any line breaks.
I know... pretty bad, huh? Hope they...
--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 22, 2007 at 6:48 am

#744111
RE: Information Technology has too little Turnover ?

Heh... yeah, I've been through that. But I will give you a tip in the form of an old proverb... "Wait not, want not". I busted my hump...
--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 22, 2007 at 6:43 am

#744109
RE: System Performance - High CPU utilization--> SQLSRV.exe

Heh... "the footbone's connected to the... shinbone... the shinbone's connect to the... kneebone..."
--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 22, 2007 at 6:40 am

#744106
RE: System Performance - High CPU utilization--> SQLSRV.exe

Won't be any effect if the Clustered key is on an IDENTITY column.
--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 22, 2007 at 1:40 am

#744020
RE: SET DATEFIRST option

Heh... sure... it'll affect the "dw" option of the other (not DATENAME) functions... nothing else... even if they were to break it in 2k5 🙂 Pretty sure they didn't,...
--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 22, 2007 at 1:37 am

#744019
RE: how to remove numbers from strings?

Sergiy (10/22/2007)
I'm sick in bed with my old laptop.
Don't have access to any server at all.
:blink:
And it was long weekend here!
Bloody hell!!! :crazy:
Heh... I'm sick too! Sick of working...
--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 22, 2007 at 1:28 am

#744017
RE: how to remove numbers from strings?

David McFarland (10/21/2007)
I ran the first code, and I believe I stated as such. That's exactly how it is used on our end, not sent to temp tables, as the...
--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 22, 2007 at 1:23 am

#744016
RE: how to remove numbers from strings?

Awesome, Lowell... thanks!
Sergiy was right... he expected about 2 times faster... sometimes, almost 3 times faster for the Inner Join.
You guys are the best! I'll start working on 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)

October 21, 2007 at 6:12 pm

#743979
RE: Information Technology has too little Turnover ?

Hi Loner...
I'd almost bet that Deborah isn't even in IT... she's probably just a reporter making an observation. I don't see where she said "my company" anywhere.
As for the...
--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 3:29 pm

#743972
RE: how to remove numbers from strings?

BTW... Sergiy, do you have convenient access to a 2k5 box that you could run these tests on? Would be real good if we had a 3rd set 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 2:10 pm

#743970
RE: how to remove numbers from strings?

Sergiy (10/21/2007)
Jeff Moden (10/21/2007)
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. ...
--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 2:06 pm

#743969
RE: Seperate digits

You bet... thanks for the feedback!
--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 2:03 pm

#743968

Viewing 15 posts - 54,481 through 54,495 (of 59,098 total)