Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,836 through 32,850 (of 59,099 total)

RE: Are the posted questions getting worse?

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available. Not 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)

August 18, 2011 at 6:37 pm

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

David Lester (8/18/2011)
Real world problems.
"Ok, write this reporting app, based off the data in this db. Oh, small point, the db is presently an Omnidex "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)

August 18, 2011 at 6:18 pm

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

Evil Kraig F (8/18/2011)
Not exactly... but..... you need xp_cmdshell to trigger independent dtexec's... :hehe:
I have just three words for that very ironic statement...
BWAAAAA-HAAAA-HAAAAAAAAAAAAAA! 😀
--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 18, 2011 at 6:15 pm

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

OzYbOi d(-_-)b (8/18/2011)
As for xp_CmdShell I've definitely been one to steer clear of it as much as possible. thanks everyone for the posts - been interesting to hear everyone's perspective...
--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 18, 2011 at 6:13 pm

#1370479
RE: How to import multiple CSV files.

Welsh Corgi (8/18/2011)
Jeff Moden (8/18/2011)
dji (8/18/2011)
If I understand correctly, though, most folks I know say that SSIS won't import "text qualified" files (files with double quotes in them if 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 18, 2011 at 6:10 pm

#1370478
RE: How to import multiple CSV files.

dji (8/18/2011)
Apologies, Jeff!
I was most definitely referring to my solution of trying to squeeze the out dated OPENROWSET into the 64 bit environment when mentioning band-aid 🙂
Understood and thank 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)

August 18, 2011 at 4:59 pm

#1370460
RE: How to import multiple CSV files.

Heh.... I actually take exception to anyone calling any import method other than SSIS a "band aid solution". Let me ask... can you execute two instances of the same...
--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 18, 2011 at 3:30 pm

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

Gary Varga (8/18/2011)
Jeff Moden (8/17/2011)
shew (8/17/2011)
We are a "locked down" hosting facility (xp_commandshell as well as a host of other features is not allowed),
Heh... xp_CmdShell. 🙂 One 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)

August 18, 2011 at 3:23 pm

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

@Gus,
Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let me say 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 18, 2011 at 2:55 pm

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

GSquared (8/18/2011)
Jeff Moden (8/18/2011)
David Lester (8/18/2011)
The 95% of the time where I would use this, and find it useful, is connected to the bcp utility. Frequently users need 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)

August 18, 2011 at 2:50 pm

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

David Lester (8/18/2011)
Sadly the reason I don't use SSIS is an IT political one. By sticking to as much version independent TSQL and pure stored procs as I can, 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 18, 2011 at 2:45 pm

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

Marios Philippopoulos (8/18/2011)
Databases are usually restored from prod backups on QA and dev environments, and those are generally non-secure environments, accessed by a lot of users.
That may be but there's...
--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 18, 2011 at 1:45 pm

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

colin.Leversuch-Roberts (8/18/2011)
My main use of xp_cmdshell is for log shipping, I use my own ( have since sql 6.0 ). Although I am looking to test using DFSR when...
--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 18, 2011 at 1:30 pm

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

David Lester (8/18/2011)
The 95% of the time where I would use this, and find it useful, is connected to the bcp utility. Frequently users need to be able 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)

August 18, 2011 at 12:50 pm

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

muthukkumaran Kaliyamoorthy (8/17/2011)
Jeff Moden (8/17/2011)
muthukkumaran Kaliyamoorthy (8/17/2011)
I tried to avoid using xp_cmdshell but sometime I can't.
Most of time I used the xp_cmdshell for deleting the old backups because the drive...
--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 18, 2011 at 12:48 pm

#1370319

Viewing 15 posts - 32,836 through 32,850 (of 59,099 total)