Forum Replies Created

Viewing 15 posts - 18,496 through 18,510 (of 59,072 total)

  • RE: Turn Out the Lights

    Henry B. Stinson (1/27/2016)

    This has gotten way off topic and has become a rant on something not even related to SQL Server.

    Heh... they're just talking about a different kind 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)

    January 27, 2016 at 7:46 am

    #1854702

  • RE: Crafting Your Resume

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

    Gary Varga (1/26/2016)

    Jeff Moden (1/25/2016)

    Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting...

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

    January 27, 2016 at 7:42 am

    #1854700

  • RE: Crafting Your Resume

    mjh 45389 (1/26/2016)

    Eric M Russell (1/26/2016)

    Alan.B (1/26/2016)

    Ivanova (1/26/2016)

    ...

    In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent 79-year old (today)...

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

    January 27, 2016 at 7:39 am

    #1854697

  • RE: Crafting Your Resume

    Eric M Russell (1/27/2016)

    mjh 45389 (1/26/2016)

    Eric M Russell (1/26/2016)

    Alan.B (1/26/2016)

    Ivanova (1/26/2016)

    ...

    In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent...

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

    January 27, 2016 at 7:36 am

    #1854696

  • RE: Need Query to know the SQl server service status

    krzysztof.ostrowski (1/26/2016)

    Jeff Moden (1/26/2016)

    It's a real shame that so many people believe that xp_CmdShell is a security risk but then will let anyone run PowerShell and still not get the...

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

    January 27, 2016 at 7:21 am

    #1854688

  • RE: Need Query to know the SQl server service status

    It's a real shame that so many people believe that xp_CmdShell is a security risk but then will let anyone run PowerShell and still not get the data into SQL...

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

    January 26, 2016 at 11:06 pm

    #1854601

  • RE: Flag Values Based on Columns

    Ed Wagner (1/23/2016)

    Eirikur Eiriksson (1/23/2016)

    Jeff Moden (1/22/2016)

    Eirikur Eiriksson (1/22/2016)

    The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for...

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

    January 26, 2016 at 8:16 pm

    #1854598

  • RE: Identify data patterns - Ran or Seq ?

    curious_sqldba (1/26/2016)

    Is there a way or any perfmon counter that could help in identifying whether my data pattern against a drive is sequential or random? Also how do i capture...

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

    January 26, 2016 at 8:05 pm

    #1854596

  • RE: Disk space

    PSB (1/26/2016)

    Hi,

    Our test server is running out of space in the G (Log files) and F drive(Data files and backups drive ) .

    We have roughly 8 user SQL databases...

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

    January 26, 2016 at 7:58 pm

    #1854595

  • RE: Multiple queries in the same stored procedure

    Manic Star (1/26/2016)

    So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached the plans at...

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

    January 26, 2016 at 7:52 pm

    #1854594

  • RE: Is there any risk involving in granting showplan permission to a dev group in devleopment UAT databases?

    SQL-DBA-01 (1/26/2016)

    Is there any risk involving in granting showplan permission to a dev group in devleopment UAT databases?

    In stark contrast to what some of the the others have suggested, 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)

    January 26, 2016 at 7:40 pm

    #1854593

  • RE: Database in full recovery?

    Johan Buis (1/26/2016)

    Hi all,

    Here's something I keep thinking about and I was wondering what your opinion would be.

    Case:

    We are running the databases of our ERP system in a simple recovery...

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

    January 26, 2016 at 10:34 am

    #1854487

  • RE: Create Text File from SELECT

    John Mitchell-245523 (1/25/2016)

    If you're using SSIS, you don't need to restrict yourself to T-SQL solutions. You'll probably find it easier to run a simple Powershell (or other scripting language)...

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

    January 26, 2016 at 10:24 am

    #1854481

  • RE: DeveloperBall

    call.copse (1/26/2016)

    It's a very difficult subject for sure. Some of the tightest team members start out seriously locking horns - is that a male thing? It sometimes seems men 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)

    January 26, 2016 at 10:19 am

    #1854479

  • RE: Database restore automate

    New persopn (1/26/2016)

    That will possible though SSIS package If you have any idea about SSIS it is easy to implement the same

    Now's your chance... how do you do 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)

    January 26, 2016 at 7:11 am

    #1854435

Viewing 15 posts - 18,496 through 18,510 (of 59,072 total)