Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 59,064 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

    • Viewing 15 posts - 1,096 through 1,110 (of 59,064 total)