Forum Replies Created

Viewing 15 posts - 18,526 through 18,540 (of 59,098 total)

  • 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

  • RE: Striped backups and cursor

    Richard Moore-400646 (1/25/2016)

    Hey Jeff,

    Thanks for your reply. Funny you should ask that as I'm in the process of testing and verifying that information. Initial tests show marginal differences...

    --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 25, 2016 at 6:45 pm

    #1854350

  • RE: Database restore automate

    Sree Divya (1/25/2016)

    hi,

    in my shared location db backup is .lbak

    Like I said, use xp_DirTree. Here's an example...

    EXEC xp_DirTree 'C:\',1,1

    Replace the "C:\" with either the drive and path 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)

    January 25, 2016 at 6:42 pm

    #1854349

  • RE: Convert a Date

    Eirikur Eiriksson (1/25/2016)

    Jeff Moden (1/25/2016)

    Yes. Not because of the low quantity but because someone else in search of code may find it and use it on something larger or...

    --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 25, 2016 at 4:50 pm

    #1854336

  • RE: Striped backups and cursor

    Richard Moore-400646 (1/25/2016)

    Thanks very much for the replies. I've corrected the counter issue and will look the versions that Luis provided.

    Shifting gears a bit, I have two questions...

    1. ...

    --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 25, 2016 at 4:47 pm

    #1854334

Viewing 15 posts - 18,526 through 18,540 (of 59,098 total)