Forum Replies Created

Viewing 15 posts - 16,831 through 16,845 (of 59,101 total)

  • RE: % of total count

    What you have to remember is, all of the costs are estimates. The only thing that ultimately matters is the actual performance.

    Here's my favorite example on performance. ...

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

    September 16, 2016 at 10:26 pm

    #1901492

  • RE: Rows to Columns

    erouse (9/16/2016)

    Can somebody please help? Is there a fairly simple way to do this?

    This is my data now.

    LABORLC

    152685A B C D E

    152969A B

    This is what I would like...

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

    September 16, 2016 at 10:02 pm

    #1901491

  • RE: Shrinking a large DB

    TheSQLGuru (9/16/2016)

    I will disagree with others about reducing the data being a good thing. Obfuscation sure, but ONLY where REQUIRED.

    The OP stated this database was to be promulgated to developers...

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

    September 16, 2016 at 9:59 pm

    #1901490

  • RE: The Danger of xp_cmdshell

    Indianrock (9/16/2016)

    ...but I think it's safe to say it would be considerably more difficult.

    No... It's not safe to say that. As with all else having to do with computers,...

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

    September 16, 2016 at 4:47 pm

    #1901483

  • RE: Are the posted questions getting worse?

    BWFC (9/16/2016)

    jasona.work (9/16/2016)

    Thom A (9/16/2016)

    ThomasRushton (9/16/2016)

    These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.

    All works...

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

    September 16, 2016 at 1:52 pm

    #1901468

  • RE: The Danger of xp_cmdshell

    roger.plowman (9/16/2016)

    This one is "convenience over security" to me, not to mention feature creep.

    xp_cmdshell really is a kind of a bad idea from an architectural standpoint, isn't it?

    Yes... almost...

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

    September 16, 2016 at 1:21 pm

    #1901460

  • RE: The Danger of xp_cmdshell

    mtassin (9/16/2016)

    Jeff Moden (9/16/2016)

    That's certainly a part of my point, though. Why even bother disabling it? Who's going to use it when it's enable? The answer 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)

    September 16, 2016 at 12:56 pm

    #1901458

  • RE: The Danger of xp_cmdshell

    Indianrock (9/16/2016)

    How so? If you meant why use powershell over xp_cmdshell ( you probably didn't mean that ), the answer would be because it has so much more functionality.

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

    September 16, 2016 at 11:43 am

    #1901433

  • RE: The Danger of xp_cmdshell

    Indianrock (9/16/2016)

    Can we expect xp_fileExist to continue functioning? Isn't it undocumented?

    Heh... Consider that you can't even rely on fully documented features to continue functioning. 😉

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

    September 16, 2016 at 11:39 am

    #1901432

  • RE: The Danger of xp_cmdshell

    FrancoisFLageole (9/16/2016)

    I just happened to work today on a script that uses that XP_CMDSHELL. I need to produce a file from a DB, and to export it to 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)

    September 16, 2016 at 11:37 am

    #1901430

  • RE: The Danger of xp_cmdshell

    SQLNightOwl (9/16/2016)

    [I agree the risk can be mitigated.

    That's what I'm talking about. People think there's a risk in using xp_CmdShell and there isn't. The only risks there are...

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

    September 16, 2016 at 10:45 am

    #1901411

  • RE: The Danger of xp_cmdshell

    Jason Markantes (9/16/2016)

    We're using xp_cmdshell for ETL's that run via java command line for a data warehouse. It is vendor supported so wasn't our decision, but it works well. We've...

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

    September 16, 2016 at 10:42 am

    #1901410

  • RE: The Danger of xp_cmdshell

    mike 62740 (9/16/2016)

    Not so simple to use PowerShell from a stored procedure if xp_cmdshell is disabled... and as I said... a trade off.

    You can easily create a job that uses/abuses...

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

    September 16, 2016 at 10:38 am

    #1901407

  • RE: The Danger of xp_cmdshell

    Indianrock (9/16/2016)

    So far I only recall trying to use powershell from a sql agent job once, but this might be a better route than xp_cmdshell.

    How so?

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

    September 16, 2016 at 8:14 am

    #1901363

  • RE: The Danger of xp_cmdshell

    mike 62740 (9/16/2016)

    I've found that there are some app developers that misuse it when it gets enabled. It has lead to some silly surprises at times from developers who 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)

    September 16, 2016 at 8:12 am

    #1901360

Viewing 15 posts - 16,831 through 16,845 (of 59,101 total)