Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 59,072 total)

  • Reply To: Data file shrink taking long time

    Another thing to add to your list is a nightly file usage check. That should also include a "Page Density" check on your indexes and heaps.  Your infrastructure guys should...

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

    September 16, 2023 at 9:29 pm

    #4287951

  • Reply To: Servicing SQL Server

    Lisa Slater Nicholls wrote:

    @jeff, while I agree with you about the most important goal, I don't think Steve meant "daily" when he said "everyday".  He meant "quotidien/mundane/matter-of-fact/run-of-the-mill/as-expected".  And no, I'm not checking...

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

    September 16, 2023 at 9:17 pm

    #4287950

  • Reply To: Are the posted questions getting worse?

    Grant Fritchey wrote:

    Jeff Moden wrote:

    Grant Fritchey wrote:

    Hey Jeff,

    I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should...

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

    September 16, 2023 at 9:13 pm

    #4287949

  • Reply To: Converting file name MMDDYYYY.txt to a Date Field

    rjjh78 wrote:

    Many thanks all for all the replies!

      Thanks for the feedback.

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

    September 16, 2023 at 2:56 am

    #4287533

  • Reply To: Banker''s rounding in T-SQL (like Math.Round in .NET)

    It's still a scalar function and your retry explains why this thread took so long and died.

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

    September 16, 2023 at 2:56 am

    #4287532

  • Reply To: Servicing SQL Server

    From the Article:

    The goal is repeatable, reliable software deployments, with releases, or at least deployments, being an everyday occurrence, not a big event.

    I have to strongly disagree... the goal is...

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

    September 16, 2023 at 2:53 am

    #4287530

  • Reply To: Banker''s rounding in T-SQL (like Math.Round in .NET)

    MarkCranness wrote:

    @Grasshopper's solution does not work for negative numbers, so here's his version that does work for negative numbers:

    create function dbo.RoundToEven(@num numeric(38,19)) returns decimal(19,2)
    begin
    return case
      ...

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

    September 16, 2023 at 2:46 am

    #4287528

  • Reply To: Are the posted questions getting worse?

    Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results...

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

    September 15, 2023 at 9:10 pm

    #4287372

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    Thanks for the post about SQL 2022, Jeff. I've reached out to my team and mentioned that we need to fix all the problems we're currently having with SQL...

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

    September 15, 2023 at 9:06 pm

    #4287371

  • Reply To: Are the posted questions getting worse?

    Grant Fritchey wrote:

    Hey Jeff,

    I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I use?

    Yes. ...

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

    September 15, 2023 at 8:57 pm

    #4287367

  • Reply To: Converting file name MMDDYYYY.txt to a Date Field

    ScottPletcher wrote:

    The only difference I see between that code and mine is CONVERT rather than CAST ... I didn't realize CAST had that "big overhead".  (Presumably using LEFT rather than...

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

    September 15, 2023 at 4:38 pm

    #4287247

  • Reply To: Converting file name MMDDYYYY.txt to a Date Field

    IF the MMDDYYYY formatted string date is guaranteed to always be 8 characters, the following works (most of the posted code doesn't consider the inclusion of the ".txt") according to...

    • This reply was modified 2 years, 9 months ago by Jeff Moden. Reason: Missed Scott Pletcher's code and added credit to him 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)

    September 15, 2023 at 4:38 am

    #4286861

  • Reply To: Converting file name MMDDYYYY.txt to a Date Field

    Deleted.  Made a mistake and didn't check before I posted. 🙁

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

    September 15, 2023 at 2:03 am

    #4286806

    • Viewing 15 posts - 1,111 through 1,125 (of 59,072 total)