Forum Replies Created

Viewing 15 posts - 18,751 through 18,765 (of 59,098 total)

  • RE: Averages over 28 days instead of a month

    Now would be a good time to shift the train of thought to ISO Weeks, which always start the year in the week that Jan 4th occurs. Since 2012...

    --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 3, 2016 at 3:16 pm

    #1849115

  • RE: Running as SysAdmin

    Cody K (12/21/2015)

    andrew gothard (12/21/2015)In fact, using a highly privileged single account for app access is nothing more than deliberate incompetence.

    The last time I heard something like this said 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 2, 2016 at 12:29 pm

    #1849078

  • RE: Calculating the status duration

    This could actually be a pretty simple thing to solve using either a self-joined re-enumerated table or the difference between two ROW_NUMBER()s. My recommendation is that you study 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 2, 2016 at 11:51 am

    #1849076

  • RE: How to manage study/practice time for sql server exams.

    mjagadeeswari (1/1/2016)

    Hi all,

    For the past few months I have been planning to

    prepare for the exam 70-462.(have done 70-461 earlier, that took for me ~5 months to complete). Tight...

    --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 2, 2016 at 11:46 am

    #1849075

  • RE: Decorations

    Ed Wagner (1/2/2016)

    I'm pretty particular on the formatting of my code, for the very reasons of readability and maintainability. I can write format that'll confuse anyone, including myself, but...

    --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 2, 2016 at 11:38 am

    #1849074

  • RE: Can i use option(recompile) for Functions?

    Kevin is correct. If you look in "Books Online", you'll find that there are 3 types of functions. Scalar Function, Multi-statement Table Valued Function (mTVF), and Inline Table...

    --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 2, 2016 at 8:00 am

    #1849064

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    John Langston (1/2/2016)

    Never thought about their being released when the application is released. I just viewed this approach as pointless since those generated query plans will never be re-used....

    --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 2, 2016 at 7:42 am

    #1849062

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    John Langston (1/1/2016)

    How about this one: the stored procedures in this vendor application where I am at are all TEMPORARY. They are created, executed, and dropped. There...

    --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 1, 2016 at 9:31 pm

    #1849050

  • RE: Is BCP queryout limited?

    dwilliscp (12/31/2015)

    Jeff Moden (12/30/2015)

    So, just to be clear.... you no longer have the original "identifier" problem?

    I tried to put the call to their code in () but got a syntax...

    --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 1, 2016 at 9:26 pm

    #1849049

  • RE: Are the posted questions getting worse?

    TomThomson (12/30/2015)

    Jeff Moden (12/29/2015)

    Lynn Pettis (12/29/2015)

    Jeff Moden (12/29/2015)

    I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have...

    --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 1, 2016 at 9:06 pm

    #1849048

  • RE: It's the end of the year

    Happy New Year, Steve! Thank you for all that you do for this wonderful community!

    --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 1, 2016 at 7:05 pm

    #1849045

  • RE: Decorations

    TomThomson (12/31/2015)

    What am awful article. The idea or putting code into some ghastly image format so that no-one can copy i and run it through whatever analysis tools they...

    --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 1, 2016 at 6:29 pm

    #1849044

  • RE: The Most Common Query Blunders...

    Heh... without going into too many details, I've found that one of the most common query blunders is the nearly religious belief in rote, so called "best practices" and some...

    --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 1, 2016 at 6:01 pm

    #1849043

  • RE: query for datetime

    drew.allen (12/31/2015)

    Jeff Moden (12/30/2015)

    Here's the code I wrote last night with the validation checks that I added today. Details are in the comments in the code.

    GREAT! But suppose 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)

    January 1, 2016 at 5:13 pm

    #1849042

  • RE: query for datetime

    Eirikur Eiriksson (12/31/2015)

    Careful here Jeff, the type cast to decimal is expensive, consider using float which does not need a type cast is less costly.

    Understood. FLOAT only has 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)

    January 1, 2016 at 5:09 pm

    #1849041

Viewing 15 posts - 18,751 through 18,765 (of 59,098 total)