Forum Replies Created

Viewing 15 posts - 19,231 through 19,245 (of 59,072 total)

  • RE: DY

    sknox (11/6/2015)

    Luis Cazares (11/6/2015)

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2 letter abbreviations...

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

    November 6, 2015 at 5:22 pm

    #1838377

  • RE: DY

    Luis Cazares (11/6/2015)

    sknox (11/6/2015)

    Luis Cazares (11/6/2015)

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2...

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

    November 6, 2015 at 5:18 pm

    #1838376

  • RE: DY

    Sean Lange (11/6/2015)

    Luis Cazares (11/6/2015)

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2 letter...

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

    November 6, 2015 at 5:16 pm

    #1838375

  • RE: DY

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    Yes... I still think that 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)

    November 6, 2015 at 5:12 pm

    #1838374

  • RE: DY

    g.britton (11/6/2015)

    Ed Wagner (11/6/2015)

    There is debate over which form to use - the full or abbreviation. The cool part is that both work. 😉

    Cool part? Or Dangerous part?...

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

    November 6, 2015 at 5:05 pm

    #1838372

  • RE: Can you replace stored procedures with sp_executesql

    Your intentions are good one's but you've walking into the lion's den wearing a pork chop necklace and gravy for hair tonic. 🙂

    The only way that you're going to 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)

    November 6, 2015 at 4:55 pm

    #1838370

  • RE: Question for All DBAs (What can I learn to enahnce my career?)

    My recommendation would be to learn the database engine inside and out along with everything you can get your hands on for T-SQL programming. I can't speak for others...

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

    November 6, 2015 at 4:19 pm

    #1838365

  • RE: return Fiscal Year based on YYYY-week format

    natividad.castro (11/6/2015)

    Thanks for your reply.

    None of the dates will define week 1 for FY16

    here are the definitions:

    2015-10-01 to 2015-10-10 ---this will be week 1 for FY16, but it's recorded as...

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

    November 6, 2015 at 4:10 pm

    #1838362

  • RE: Today's Random Word!

    anthony.green (11/6/2015)

    Ed Wagner (11/6/2015)

    anthony.green (11/6/2015)

    djj (11/6/2015)

    crookj (11/6/2015)

    Ed Wagner (11/6/2015)

    anthony.green (11/6/2015)

    Igor Micev (11/6/2015)

    CATCH

    Error

    Log

    Audit

    Account

    Bank

    Fees

    extortionate

    Obama Care

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

    November 6, 2015 at 8:03 am

    #1838240

  • RE: Are the posted questions getting worse?

    Sean Lange (11/5/2015)

    xsevensinzx (11/5/2015)

    Ed Wagner (11/5/2015)

    Sean Lange (11/5/2015)

    xsevensinzx (11/4/2015)

    Jeff Moden (11/4/2015)

    Brandie Tarvin (11/4/2015)

    Jeff Moden (11/3/2015)

    Man o man... yet another self-proclaimed DBA bites the dust in the interview process as 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)

    November 5, 2015 at 7:23 pm

    #1838130

  • RE: What's taking up all my disc space

    DamianC (11/5/2015)

    Hi

    Thanks for the replies

    Basically, MDF, LDF and TempDB are all on the same disk, on the same drive (E)

    I am aware this is not optimal and I am going...

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

    November 5, 2015 at 8:30 am

    #1837992

  • RE: Kill hung xp_cmdshell child process from SQL

    There are only two valid ways to kill a stuck xp_CmdShell call. One is to bounce the whole server, not just the SQL Service. Obviously, that's even worse...

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

    November 5, 2015 at 7:48 am

    #1837980

  • RE: XP_CMDSHELL fails execution

    John Parker-202766 (7/4/2008)

    Toby,

    thank you for your response. After restarting the service, all was well.

    John P.

    What you don't know is that whatever xp_CmdShell was running, is still running! Restarting...

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

    November 5, 2015 at 7:33 am

    #1837971

  • RE: Best solution for reporting on a secondary server

    rohan1424 (11/1/2015)

    Hi JakDBA ,

    Thanks for your suggestion . We do not have a dedicated resources and experience to implement and maintain always on .

    Hi Jeff ,

    Thanks for your...

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

    November 4, 2015 at 11:23 pm

    #1837869

  • RE: How do I query an Access 2013 (v15.0) database from SSMS (SQL Server 2008 R2)?

    Ancient Coder (11/4/2015)

    Same error when using a linked server.

    Odd that SSIS (using a DTS connection string) works but SSMS doesn't. Both are using "Provider=Microsoft.Jet.OLEDB.4.0", too.

    Regardless of what SSIS does, if...

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

    November 4, 2015 at 11:15 pm

    #1837866

Viewing 15 posts - 19,231 through 19,245 (of 59,072 total)