Forum Replies Created

Viewing 15 posts - 16,801 through 16,815 (of 59,067 total)

  • 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

  • RE: % of total count

    Alan.B (9/15/2016)

    Gazareth (9/15/2016)

    Also SUM with OVER()

    DECLARE @table TABLE (stateName varchar(20), Count1 int, TotalChargeOffAmount int);

    INSERT @table

    VALUES

    ('Alabama',5,1000),

    ('Arizona',2,4000),

    ('Arkansas',3,5000);

    SELECT

    stateName,

    Count1,

    TotalChargeOffAmount,

    100.0*Count1 / SUM(t1.[Count1])...

    --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 7:18 am

    #1901334

  • RE: Want to learn SQL

    chatwithgeorgelucas (9/15/2016)

    Dear Friends,

    Please suggest me some sites to learn SQL online. Thanks in advance.

    Lookup "SQL Tutorial" on Yabingooglehoo.

    --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:13 am

    #1901270

  • RE: Down Tools Week 2016

    Steve Jones - SSC Editor (9/15/2016)

    Jeff Moden (9/14/2016)

    From the Article:

    An organization wouldn't need to cater food every night.

    Night? Free brainstorming for the company and it's at night?

    I've heard of "Down...

    --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 15, 2016 at 11:49 pm

    #1901268

  • RE: Add unique valules to a heap

    durga.palepu (9/1/2016)

    Yes, its always a best practice to have a primary key on table to avoid the heap. It can be either simple identity column or any business key.

    Also...

    --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 15, 2016 at 11:37 pm

    #1901266

Viewing 15 posts - 16,801 through 16,815 (of 59,067 total)