Forum Replies Created

Viewing 15 posts - 17,806 through 17,820 (of 59,102 total)

  • RE: SQL -> Excel

    Steve Jones - SSC Editor (4/26/2016)

    Email the article(s), and feel free to focus separate pieces on a smaller part.

    The problem isn't with your machine. Probably in the chair in front...

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

    April 26, 2016 at 4:19 pm

    #1874818

  • RE: Storing encypted SSN's

    Eric M Russell (4/26/2016)

    A SSN hashed using MD5 can be un-hashed by simply joining it on a dictionary table prepopulated with a billion sequential SSN codes that were hashed using...

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

    April 26, 2016 at 4:13 pm

    #1874817

  • RE: SQL Server Resource Governor

    Thanks for the article, Raul. I especially like what I saw on the PerfMon chart in the "Results" section.

    Not much to add because Kevin beat me too 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)

    April 26, 2016 at 3:51 pm

    #1874812

  • RE: Storing encypted SSN's

    ram302 (4/26/2016)

    I will never need to decrypt the SSN, but I will need to add/remove ones as personnel are hired/terminated. Also, the table itself may contain multiple entries for 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)

    April 26, 2016 at 10:59 am

    #1874702

  • RE: Storing encypted SSN's

    ram302 (4/25/2016)

    Hi all,

    First of all, I am against the use of SSN's as UID; but, such is the way the database has been constructed. This data will be imported frequently;...

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

    April 26, 2016 at 8:30 am

    #1874648

  • RE: Processing strings.

    Solomon Rutzky (4/25/2016)

    Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and C#. Since that isn't...

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

    April 26, 2016 at 8:21 am

    #1874642

  • RE: SQL -> Excel

    Oooo.... I've got an awesome one that automatically adjusts for changes in the spreadsheet with no changes to the code. Have done a presentation on it a couple 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)

    April 26, 2016 at 8:17 am

    #1874638

  • RE: DIR /B switch

    p.s. You did see my post on how to determine if a file was open or not? Does that help?

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

    April 26, 2016 at 7:39 am

    #1874610

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    Thank you Jeff, I cannot rename files on Server1 due to some logic, presented only on Server2

    I am inserting the results of xp_cmdshell 'DIR /B PATH' to the table...

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

    April 26, 2016 at 7:38 am

    #1874607

  • RE: @TrumpDBA!

    Ah... got in. The link had some strange characters at the end. Remove those and you're in. Heh... "Trust me! I Guarantee IT!" 😀

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

    April 25, 2016 at 10:11 pm

    #1874434

  • RE: @TrumpDBA!

    Wayne West (4/25/2016)

    Why would you need database advice from anywhere or anyone else?!

    https://twitter.com/trumpdba[/url]

    ETA: This post was probably written for Jeff:

    RBAR is more work. More work means MORE JOBS FOR AMERICA!...

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

    April 25, 2016 at 9:45 pm

    #1874433

  • RE: DIR /B switch

    Heh... one more thought. Why not just use the "&&" and "||" decision notation with the rename command instead of the double redirection with a nul write?

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

    April 25, 2016 at 9:01 pm

    #1874427

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    Hello,

    I am copying files on Server1 to a certain folder on the network share folder every 10 mins. Some of the files a quite big.

    On Server2 I need...

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

    April 25, 2016 at 8:59 pm

    #1874426

  • RE: DIR /B switch

    inHouseDBA (4/25/2016)

    yes, you are right, but I was using that as part of the sql processing, so I was hoping that someone might know.

    Here's an example DOS command that 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)

    April 25, 2016 at 8:57 pm

    #1874425

  • RE: Statistics on every column?

    MadAdmin (4/25/2016)

    Jeff Moden (4/25/2016)

    Thanks for the answers, folks. Everything is pretty much as I thought but had to make sure. Lot's o' experienced folks out there and I'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)

    April 25, 2016 at 3:09 pm

    #1874382

Viewing 15 posts - 17,806 through 17,820 (of 59,102 total)