Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,216 through 40,230 (of 59,098 total)

RE: Eliminating invalidly formatted decimal text strings

You can't use ISNUMERIC alone because things like '2e3' and '2d3' are valid "convertable" numbers according to ISNUMERIC so be sure to also include whatever other logic you already have...
--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)

January 19, 2010 at 10:45 pm

#1105840
RE: Find different values for related orders?

Marcus Farrugia (1/19/2010)
Hi from the temp table below I would like to see related orders that were actioned by different employees. So for RelatedID 1 employee B & C...
--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)

January 19, 2010 at 10:40 pm

#1105837
RE: copy using xp_cmdshell

exec xp_cmdshell 'copy "C:\Documents and Settings\Lucky\My Documents\CKM\Test.xml" "c:\test.xls"'
--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)

January 19, 2010 at 10:29 pm

#1105834
RE: Selecting records that match user-entered keywords

Why couldn't you just use whatever you're using to distribute the search terms across columns for exactly what you just wrote above?
--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)

January 19, 2010 at 10:28 pm

#1105833
RE: Help Others, Help Yourself

But there is another, often unplanned, effect: when you spend time helping others, you also improve your own skills.
By golly, Tim... truer words never spoken. Excellent editorial by one...
--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)

January 19, 2010 at 10:23 pm

#1105831
RE: does a stored procedure recognize its 'caller'

I agree with Lynn... while it's certainly OK to have more than one query in a stored procedure, conditional execution of two stored procedures isn't the optimal thing to 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)

January 19, 2010 at 10:16 pm

#1105830
RE: Couldn't run restore database command from perl DBI

I'm not a Perl user so, sorry, no joy there. I am curious, though... why are you using Perl to execute restores?
--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)

January 19, 2010 at 10:10 pm

#1105826
RE: Is it possible to limit the resource utilization for a particular process running on MSSQL database

If the "process" is controlled by a stored procedure or set of stored procedures, you can do things like setting OPTION(MAXDOP 1) to help the situation a bit. 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)

January 19, 2010 at 10:04 pm

#1105824
RE: "A significant part of sql server process memory has been paged out. This may result in a performance degradation"

muruecos (1/18/2010)
Hello, I have the following problem:
"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set...
--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)

January 19, 2010 at 10:00 pm

#1105823
RE: Date and time Display

I've never heard of displaying decimal minutes with a colon instead of a decimal point. At the very least, that will confuse the hell out of the uninitiated. 😉
--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)

January 19, 2010 at 9:54 pm

#1105820
RE: SQL SERVER 2008 Pivot

Change your EXECUTE to a PRINT and let's see what you get...
--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)

January 19, 2010 at 9:51 pm

#1105819
RE: Perfect is the Enemy of Good

p.s. Andy, that's not directed at you or anyone in particular. You just happened to hit a "sweet" spot (or is that "sweat" spot :-P) with me. ...
--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)

January 19, 2010 at 9:47 pm

#1105818
RE: Perfect is the Enemy of Good

I agree that "perfect" is sometimes the enemy of the "good"...
...but that's usually just some garbage excuse by people who don't really care to begin with. Think about it......
--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)

January 19, 2010 at 9:32 pm

#1105815
RE: Perfect is the Enemy of Good

roger.plowman (1/19/2010)
GOC-481399 (1/19/2010)
Be good to see an alternative article on how to maintain your standards when thrown into a (purely hypothetical of course) BI/Reporting team where:

Nothing is documented...

--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)

January 19, 2010 at 8:49 pm

#1105808

RE: Knowledge Transfer

george sibbald (1/18/2010)
access methods and passwords

Allow me to emphasize what George said above... make darned sure you have ALL the SA and DBA passwords! If this person leaving also...

--Jeff Moden

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)

January 19, 2010 at 8:43 pm

#1105806

Viewing 15 posts - 40,216 through 40,230 (of 59,098 total)