Forum Replies Created

Viewing 15 posts - 6,886 through 6,900 (of 59,072 total)

  • Reply To: Banker’s Rounding. What is it good for?

    <quote>From the Last Sentence of the Conclusion in the Article...

    To maintain the best precision of the final result all intermediate calculations must be performed on numbers in floating point formats,...

    --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 15, 2020 at 12:29 pm

    #3763089

  • Reply To: Sum days for fiscalyear

    cbrammer1219 wrote:

    I've attached a screen shot of the table definitions.

    Ya know... If you were to post an actual CREATE TABLE bit of code for the pertinent columns for this problem...

    --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 15, 2020 at 1:02 am

    #3762998

  • Reply To: Performance Tuning a SQL Server Database in Amazon RDS

    I have to ask... were the databases previously on-premise?  If so, did they "work fine"?

     

    --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 14, 2020 at 8:09 pm

    #3762981

  • Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

    VoldemarG wrote:

    Also, please enjoy sp_Who3

    https://www.sql.ru/forum/96127/sp-who3

    Perhaps the author should spend a bit more time on it first.

    Msg 8152, Level 16, State 13, Line 1

    String or binary data would 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 14, 2020 at 7:28 pm

    #3762978

  • Reply To: Are You a Gatekeeper?

    Just like the best managers, "GateKeepers" must not be just enforcers... they must also be "servant-providers".   That doesn't mean they should just rollover and give in just because someone wants...

    --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 14, 2020 at 3:07 pm

    #3762964

  • Reply To: Two Strings compare using t-sql

    Jus wrote:

    Worked like a champ. Thanks jeff.

    😀  Thanks for the feedback.

    To be sure, though, do you understand how and why it works?

     

    --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 14, 2020 at 3:27 am

    #3762907

  • Reply To: All info about all Extended Events on the server - how can i get it via a query?

    VoldemarG wrote:

    and what are advantages of using trace flags for saving deadlock data to transaction log compared to seeing them in the default XE sessions?

    Heh... it's a part of EVERYTHING...

    --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 14, 2020 at 3:25 am

    #3762906

  • Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

    Frederico mentioned the most important thing in his very first sentence, which is...

    frederico_fonseca wrote:

    you don't need to measure everything - if someone asked you to do that they don't know...

    --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 14, 2020 at 3:21 am

    #3762905

  • Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

    VoldemarG wrote:

    Thank you, Jeff,  for your

    very valuable comment. And I am doing that , too (top 10 worst , etc.).

    but aside along from that, there is a specific question asked...

    --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 14, 2020 at 3:01 am

    #3762902

    • Viewing 15 posts - 6,886 through 6,900 (of 59,072 total)