Forum Replies Created

Viewing 15 posts - 20,431 through 20,445 (of 59,072 total)

  • RE: Native Audits

    phegedusich (6/8/2015)

    Jeff, Guardium captures the activity and provides very granular reporting capabilities (who did what when). It's read-only as far as interaction with SQL Server. A Guardium user can't 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)

    June 8, 2015 at 4:40 pm

    #1803854

  • RE: Should Salary Information Be Confidential?

    Andy Warren (6/8/2015)

    Jeff, maybe I didnt ask the question well. I'm not arguing with your choices - yours to make! Just curious to understand if/why joining a company that has...

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

    June 8, 2015 at 4:15 pm

    #1803852

  • RE: Should Salary Information Be Confidential?

    Eric M Russell (6/8/2015)

    Jeff Moden (6/8/2015)

    Eric M Russell (6/8/2015)

    Jeff Moden (6/8/2015)

    Andy Warren (6/8/2015)

    Jeff, would you decline an offer from a company that publishes all salaries?

    Yes.

    Even if the company were financially...

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

    June 8, 2015 at 4:07 pm

    #1803851

  • RE: Restore Sequence

    Now for a question to you... Your avatar is of a book cover for a "Complete Guide to Database Administration". Isn't this information in that book?

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

    June 8, 2015 at 2:53 pm

    #1803831

  • RE: Should Salary Information Be Confidential?

    Andy Warren (6/8/2015)

    Government work is definitely a different thing. Like any job, it has good and bad. Disclosure of salary would not be for me a factor in deciding.

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

    June 8, 2015 at 9:07 am

    #1803723

  • RE: Should Salary Information Be Confidential?

    robert.sterbal 56890 (6/8/2015)

    Does that mean you wouldn't take a government job either?

    I've been in the military, I've worked for a DOD company, and I've had regular dealings with the military...

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

    June 8, 2015 at 8:33 am

    #1803704

  • RE: Should Salary Information Be Confidential?

    Eric M Russell (6/8/2015)

    Jeff Moden (6/8/2015)

    Andy Warren (6/8/2015)

    Jeff, would you decline an offer from a company that publishes all salaries?

    Yes.

    Even if the company were financially stable, the IT projects interesting,...

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

    June 8, 2015 at 8:25 am

    #1803700

  • RE: Should Salary Information Be Confidential?

    Andy Warren (6/8/2015)

    Jeff, would you decline an offer from a company that publishes all salaries?

    Yes. I haven't had to though because I research the companies that I apply to and...

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

    June 8, 2015 at 8:07 am

    #1803692

  • RE: The Multi-skilled Developer

    Vanessa.Grimes (6/8/2015)

    @Grasshopper "Developers are knowledgeable about narrow topics. They think in tiny bits and move from bit to bit in the process of creating software." That's a bit condescending...

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

    June 8, 2015 at 7:57 am

    #1803688

  • RE: Should Salary Information Be Confidential?

    Sean Redmond (6/8/2015)

    If salaries are to be revealed for one, they are to be revealed for all.

    I appreciate the sentiment but someone might use such sentiments for justification 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)

    June 8, 2015 at 7:34 am

    #1803678

  • RE: The Multi-skilled Developer

    The best communication methods and systems in the world are totally useless unless a company adopts a development and maintenance policy that few companies seem to implement and can be...

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

    June 7, 2015 at 10:06 am

    #1803543

  • RE: The Multi-skilled Developer

    TomThomson (6/6/2015)

    Jeff Moden (6/5/2015)

    You don't have to win to plant a seed. Even a cement parking lot, like your Dev Guy, has a crack in it. 😉

    Great article,...

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

    June 6, 2015 at 7:49 pm

    #1803533

  • RE: Clearing Temp tables

    patelxx (6/6/2015)

    I am just learning about temp temps using Iteration, how do I clear the contents of the #temp table because when I re-run the query I get the following...

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

    June 6, 2015 at 6:22 am

    #1803510

  • RE: UNPIVOT behaves differently in 2005 and 2010/2012

    autoexcrement (6/5/2015)

    I am in the process of migrating some gnarly old SSIS packages from SQL Server 2005 to SQL Server 2012. The only piece that is behaving discrepantly is an...

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

    June 5, 2015 at 11:31 pm

    #1803506

  • RE: DB size

    You also need some headroom for certain maintenance such as REBUILDing indexes. Any index over 128 extents (that's just 8 megabytes) that needs to be rebuilt will first be...

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

    June 5, 2015 at 11:21 pm

    #1803504

Viewing 15 posts - 20,431 through 20,445 (of 59,072 total)