Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 59,091 total)

  • Reply To: High sensitivity of SQL server 2016 to statistics ?

    To be clear, the link you posted from stack overflow cites TF 4199 and I'm not talking about that.  I'm talking about TF 9481, which fixed my issues when, like...

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

    May 22, 2020 at 2:41 pm

    #3756860

  • Reply To: Cleanup Sysmail -items from msdb

    Awesome.  Thanks for the feedback, Bruin.

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

    May 22, 2020 at 2:07 pm

    #3756852

  • Reply To: Writing Before Reading

    Steve Jones - SSC Editor wrote:

    Jeff Moden wrote:

    +1 Billion to Roger Plowman for his post above.  I'll also add that commenting code when you're writing it is pretty simple.  The first thing I normally do...

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

    May 21, 2020 at 4:47 pm

    #3756639

  • Reply To: Writing Before Reading

    Tom_Hogan wrote:

    Jeff Moden wrote:

    ...The first thing I normally do is to write the comments of the things I need to get done and why.  That also creates a bit 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)

    May 21, 2020 at 2:57 pm

    #3756601

  • Reply To: High sensitivity of SQL server 2016 to statistics ?

    martinreiser wrote:

    Any suggestions ?

    I think you missed the suggestion about reverting to the old Cardinality Estimator, which DID fix the same problems we were having when we made the same...

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

    May 21, 2020 at 2:05 pm

    #3756577

  • Reply To: Import a text file into SQL Server table without BULK insert due to special char

    rip wrote:

    The text file was UTF-8 and we used CODEPAGE = 65001 and were able to process successfully.

    set @Str1 = 'Select * Into ##TempPerson FROM OPENROWSET (BULK '''

    set @Str2 =...

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

    May 21, 2020 at 1:54 pm

    #3756572

  • Reply To: Writing Before Reading

    +1 Billion to Roger Plowman for his post above.  I'll also add that commenting code when you're writing it is pretty simple.  The first thing I normally do is 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)

    May 21, 2020 at 1:45 pm

    #3756569

  • Reply To: Result data for date, even when it doesn't exist

    jcelko212 32090 wrote:

    Play with the idea of having a calendar table and then doing a set-oriented EXCEPT operator to find the missing dates and insert a row with the dummy values...

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

    May 20, 2020 at 9:09 pm

    #3753424

  • Reply To: Memory Optimized tables for speeding inserts and updates

    p.s. Even in SQL Server 2016, there's still a limit of the In Memory stuff of 250GB.  In the databases of today, that means you have to be a wee...

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

    May 20, 2020 at 9:03 pm

    #3753418

  • Reply To: Memory Optimized tables for speeding inserts and updates

    I didn't mean that as a slam.  It's just not possible to post general guidlines because everyone's stuff is different.  I just watched the following YouTube on the subject... every...

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

    May 20, 2020 at 8:55 pm

    #3753417

  • Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

    Yep... let's go back to square one... if they were to move to Teradata and do the same types of things that they've done with their SQL Server, they'd still...

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

    May 20, 2020 at 8:47 pm

    #3753416

  • Reply To: Memory Optimized tables for speeding inserts and updates

    Sorry... you're not going to like this.  My general guideline for things as important as Memory Optimized data is to Google for the documentation and read about it because 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)

    May 20, 2020 at 5:36 pm

    #3753355

    • Viewing 15 posts - 7,051 through 7,065 (of 59,091 total)