Forum Replies Created

Viewing 15 posts - 9,451 through 9,465 (of 59,091 total)

  • Reply To: How to Capture Deleted Records

    I cannot. I'm just a "user" of this forum just like everyone else. You might try contacting webmaster@sqlservercentral.com with your request.

    --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 18, 2019 at 5:58 pm

    #3455194

  • Reply To: TempDB File Size Per TempDB FIle

    Thanks for the feedback.

    --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 18, 2019 at 5:37 pm

    #3454984

  • Reply To: How to Capture Deleted Records

    mohsen.bandamir wrote:

    Great Article. But Unfortunately I can't find attached file!!! anyone can help?

    It's going to be a bit... the new forum software has a problem in it that made all...

    --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 18, 2019 at 5:29 pm

    #3454750

  • Reply To: ethical question

    Heh... and here we are trying to teach someone on an interview to be either a DBA or a Developer how to be ethical.  This should be an innate attribute...

    --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 18, 2019 at 4:09 pm

    #3453384

  • Reply To: Hash Social Security Number

    Heh... I wasn't going to tell the OP about that... I didn't want to make it any easier for him to do it the wrong way.  The SSNs have 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)

    April 18, 2019 at 1:58 pm

    #3451049

  • Reply To: Are the posted questions getting worse?

    below86 wrote:

    Jeff Moden wrote:

    Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs.  Had...

    --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 18, 2019 at 1:52 pm

    #3451031

  • Reply To: Adjusting T-sql to prevent injection

    This guy has asked a half dozen interview questions.  I'm not helping him to get a job he's not qualified to 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)

    April 18, 2019 at 1:47 pm

    #3451008

  • Reply To: another changing code to prevent injection

    Thom A wrote:

    Are these all interview/homework questions? ethical question, replication, Adjusting T-sql to prevent injection, accidenly dropping production, failover, idol steps to take. Why don'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 18, 2019 at 1:44 pm

    #3450985

  • Reply To: Returning table with variable number of columns (PIVOT?)

    Louis Hillebrand wrote:

    Another option it to dynamically create the resulting table. Starting from a table with all the items and an empty price column, and loop through all the price lists....

    --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 18, 2019 at 1:32 pm

    #3450912

  • Reply To: idol steps to take

    Lordy... all these interview questions you're asking.  And the word should be "ideal" and not "idol". 😉

     

    The bottom line should be that NO ONE gets any privs to prod without...

    --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 18, 2019 at 1:23 pm

    #3450851

  • Reply To: accidenly dropping production

    Again, this sounds like another interview question.  Again, I'll only provide hints because if you're applying for a DBA job, it's YOU that has to learn and simple memorization 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 18, 2019 at 1:20 pm

    #3450830

  • Reply To: ethical question

    This sounds like an interview question... especially since you've asked so many similar questions.

    I'll give you some hints, though...

    BEGIN TRANSACTION

    ABSOLUTE HONESTY

    --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 18, 2019 at 1:16 pm

    #3450817

  • Reply To: Sorting Months By Number (SQL Spackle)

    @s-2.bellini

    Yes, I appreciate that a lot of people abuse TempDB and thanks for the feedback there.  For these type of articles, though, I can't presume that it's safe to sometimes...

    --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 18, 2019 at 1:13 pm

    #3450790

  • Reply To: SQL Server Agent scheduled job taking too long time to run in SQL Server 2014

    If you did a shrink-file, you inverted some index and that's the worst form of fragmentation there is.  You MUST do index maintenance to any fragmented index immediately after 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)

    April 18, 2019 at 5:07 am

    #3442120

    • Viewing 15 posts - 9,451 through 9,465 (of 59,091 total)