Forum Replies Created

Viewing 15 posts - 601 through 615 (of 59,099 total)

  • Reply To: Are the posted questions getting worse?

    Greg Edwards-268690 wrote:

    The irony is a company selling products that are software / code has a forum they support that has gotten buggier over time. This in some respects is 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)

    May 15, 2024 at 4:44 am

    #4421363

  • Reply To: Are the posted questions getting worse?

    Bumping a post so that Greg's post above shows up.  It wasn't showing because it was the first post on a page, and that's just one of the problems on...

    --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 15, 2024 at 4:38 am

    #4421361

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    Jeff Moden wrote:

    Steve Jones - SSC Editor wrote:

    sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails 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 14, 2024 at 11:49 pm

    #4421328

  • Reply To: Are the posted questions getting worse?

    Robert Sterbal-482516 wrote:

    I sent this post on X:

    https://twitter.com/rsterbal/status/1790436470181818647

    Robert Sterbal 412-977-3526 call/text

    @rsterbal

    @redgate Who should I reach out to for issues with the https://sqlservercentral.com forums? Is there a place to post and follow...

    --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 14, 2024 at 11:33 pm

    #4421327

  • Reply To: Crazy Interviews

    Steve Jones - SSC Editor wrote:

    jasona.work wrote:

    Jeff Moden wrote:

    Heh... GETDATE(). 😀

    SELECT SYSDATETIMEOFFSET();

    🙂

    exec xp_cmdshell('date /t')

    😛 It IS a great litmus strip test.

     

    --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 14, 2024 at 8:49 pm

    #4421306

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails to me.

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

    May 14, 2024 at 12:18 am

    #4421028

  • Reply To: Script to Merger duplicate indexes

    Dennis Jensen wrote:

    Really Jeff Moden that would be interesting to read (or see) -- your proof in a presentation -- as I find that a rather interesting stance and would greatly...

    --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 13, 2024 at 10:33 pm

    #4421019

  • Reply To: Script to Merger duplicate indexes

    Dennis Jensen wrote:

    Jeff Moden based on what ScottPletcher stated I do not see how one would end up with 2 Indexes as he did state you Drop one of the Indexes...

    --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 13, 2024 at 9:43 pm

    #4421007

  • Reply To: Script to Merger duplicate indexes

    ScottPletcher wrote:

    Jeff Moden wrote:

    ScottPletcher wrote:

    You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

    I've started on code to do this...

    --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 13, 2024 at 9:29 pm

    #4420999

  • Reply To: Are the posted questions getting worse?

    Bump post to get my message to show up because it's the first post on a new page. 🙁

    --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 13, 2024 at 4:41 pm

    #4420913

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    Jeff Moden wrote:

    @steve-2 :

    I guess my question would be, what are the marketing stats for the site?  Perhaps a bit of understanding there would help us shape our requests...

    --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 13, 2024 at 4:38 pm

    #4420912

  • Reply To: Script to Merger duplicate indexes

    As for scripts to "find duplicates", they have this new fangled thing called a "search engine". 😀

    Try the following search and see what you come up with.  I haven't looked...

    --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 13, 2024 at 4:35 pm

    #4420911

  • Reply To: Script to Merger duplicate indexes

    ScottPletcher wrote:

    You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

    I've started on code to do this process 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)

    May 13, 2024 at 4:28 pm

    #4420908

    • Viewing 15 posts - 601 through 615 (of 59,099 total)