Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 59,082 total)

  • Reply To: What is ChatGPT – Is it the rise of the Skynet era?

    Good grief.  It just keeps getting worse.  Even 99.9% logical fragmentation has absolutely no effect on index SEEKs but ChatGPT would have you believe the opposite is true

    .

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

    February 16, 2023 at 10:33 pm

    #4150799

  • Reply To: Alternative to row_number in natively compiled stored procedure

    MullerN wrote:

    I found an alternative to my specific problem. I used the identity to also sort the data and had another column that I could use to sort the data....

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

    February 16, 2023 at 7:47 pm

    #4150743

  • Reply To: Improving Skills at Work

    Rod at work wrote:

    Steve Jones - SSC Editor wrote:

    FWIW, Jeff, it would be great to see a list of common SQL problems that people ought to be able to solve. I'd add in

    • running totals
    • deserializing...

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

    February 16, 2023 at 7:40 pm

    #4150736

  • Reply To: Need to do a mass update - taking days

    Ed B wrote:

    Trust me, I don’t use format specifically because of your previous remarks. I changed as little as possible to illustrate a point.

    Ah... now I understand.  Heh... I thought "WTH? ...

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

    February 16, 2023 at 3:38 am

    #4150354

  • Reply To: Need to do a mass update - taking days

    krypto69 wrote:

    Thanks Jeff!

    Hey wait...So format not so great? Googling now...

    Don't "Google It".  Most people don't have a clue about it.  Go read the article I provided the link for.  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)

    February 16, 2023 at 3:34 am

    #4150353

  • Reply To: Dealing with super huge table which is partially partitioned.

    Also, what would you folks partition the table on? The reason I ask that is that I DO have a partitioned table.  It's only about 2TB with 10 years 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)

    February 16, 2023 at 3:30 am

    #4150352

  • Reply To: The Cost of the Cloud

    Heh... Some of the people I've had to work with in the past seem to make a pretty good living at "If it ain't broke, fix it until is" mantra....

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

    February 16, 2023 at 3:05 am

    #4150348

  • Reply To: Dealing with super huge table which is partially partitioned.

    Crud... forum software lost my page on page 2... "bumping" that page with this post to get it to show up.

     

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

    February 16, 2023 at 2:52 am

    #4150338

  • Reply To: Dealing with super huge table which is partially partitioned.

    I'm curious... has anyone checked to see if any of that 17TB can be archived and moved out of the main 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)

    February 16, 2023 at 2:49 am

    #4150337

  • Reply To: Aggregate Select Results and convert Secs to Hours Mins.

    @Wecks ...

    Getting back to the subject and with the understanding that I try to anticipate the proverbial "next question" from my users, here's what I'd do along with some documentation...

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

    February 16, 2023 at 2:22 am

    #4150334

  • Reply To: Aggregate Select Results and convert Secs to Hours Mins.

    BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do.  The technology behind all of that is mind boggling .  My biggest...

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

    February 16, 2023 at 2:05 am

    #4150332

  • Reply To: Need to do a mass update - taking days

    Ok... I'm playing with a copy of the Person.Person table from a copy of the Adventure Works database.  I created 3 "scratch" tables, one for each name column, and populated...

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

    February 16, 2023 at 1:33 am

    #4150308

    • Viewing 15 posts - 1,891 through 1,905 (of 59,082 total)