Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,866 through 32,880 (of 59,099 total)

RE: If you could use xp_CmdShell securely, would you?

Roy Ernest (8/17/2011)
We do not use xp_cmdshell because of the bad rep. The only time we used it was when we were migrating to the new server. At that 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)

August 17, 2011 at 9:58 am

#1369713
RE: If you could use xp_CmdShell securely, would you?

ALZDBA (8/17/2011)
Perry Whittle (8/17/2011)
Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful use....
--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)

August 17, 2011 at 9:53 am

#1369707
RE: If you could use xp_CmdShell securely, would you?

Jayanth_Kurup (8/17/2011)
Probably not in production. While there are secure ways of using xp_cmdshell. I can't/won't trust everybody to use it the way its meant to be. I could leave 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)

August 17, 2011 at 9:47 am

#1369699
RE: If you could use xp_CmdShell securely, would you?

Perry Whittle (8/17/2011)
Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful use.
I...
--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)

August 17, 2011 at 9:37 am

#1369692
RE: Upgrade path gap? You cant get there from here?

I apologize that this post is of no help in solving your problem other than maybe "bumping" your post for you. I just wanted to make the observation that...
--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)

August 16, 2011 at 11:21 pm

#1369411
RE: nothing returning for date

spin (8/15/2011)
hi
the reason i wanted this...
select * from Sales.SalesOrderHeader
where OrderDate between 01/01/2004 and 31/12/2004
...is because i'm trying out SSRS using BIDS. i wanted the date to be a parameter value...
--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)

August 16, 2011 at 11:15 pm

#1369409
RE: How to modify $pshome PowerShell 2.0 variable so that it points to a different directory

I've got no problem with that. I've been known to use it myself. It's a tried and true method so long as you're protecting the passwords with either...
--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)

August 16, 2011 at 10:31 pm

#1369403
RE: Extracting only the date part (leave out time)

Evil Kraig F (8/16/2011)
Jeff Moden (8/16/2011)
A second run without rebuilding the test table shows a slightly different story, as well...
========== DATEADD/DATEDIFF ==========
SQL Server Execution Times:
CPU 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)

August 16, 2011 at 9:57 pm

#1369401
RE: a=b=c?

@Yin Halen,
My apologies... I didn't mean to hi-jack your thread. Are you all set now?
--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)

August 16, 2011 at 9:36 pm

#1369397
RE: a=b=c?

R.P.Rozema (8/16/2011)
I know, the example was far fetched. And as I said: there are far better ways to implement the example. Still I don't share your idea that readability is...
--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)

August 16, 2011 at 9:32 pm

#1369396
RE: My Query Runs Too Quickly

homebrew01 (8/16/2011)
Ok, what I really mean is, that I want to try some different code to test performance.
When I ran query ver #1, it took 4 minutes.
Then I make 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)

August 16, 2011 at 5:43 pm

#1369383
RE: Turn integer into time of day

baileyc411 (8/16/2011)
I am sad to say I haven't been able to figure this out. I have a table with a Start Time and an End Time, but it listed as...
--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)

August 16, 2011 at 5:11 pm

#1369376
RE: How to modify $pshome PowerShell 2.0 variable so that it points to a different directory

I know it doesn't help but this is one of the many reasons why I try to do as much as possible from T-SQL. 😉
--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)

August 16, 2011 at 5:03 pm

#1369375
RE: Converting a string date to formatted int date

tacy.highland (8/16/2011)
Another good point. Thanks for all the help.
Question though, if this column is in Date format and the other fields are smalldatetime and I do a DATEDIFF between 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)

August 16, 2011 at 4:50 pm

#1369371
RE: a=b=c?

R.P.Rozema (8/16/2011)
Jeff Moden (8/16/2011)
what else could you use ALL for? I ask because I've never found the need to make sure that multiple column values in the same row...
--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)

August 16, 2011 at 2:57 pm

#1369330

Viewing 15 posts - 32,866 through 32,880 (of 59,099 total)