Forum Replies Created

Viewing 15 posts - 2,701 through 2,715 (of 59,086 total)

  • Reply To: Query memory grant

    sqlguru wrote:

    Thanks. I agree with you. But this is read only copy used for reporting. We are looking for other ways to improve performance by adding more memory but also...

    --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 23, 2022 at 8:53 pm

    #4091361

  • Reply To: Query memory grant

    sqlguru wrote:

    We have reporting server and thinking of limiting the max percentage granted to each query. So it will use less memory than desired. I know there are some cons...

    --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 23, 2022 at 6:31 pm

    #4091316

  • Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

    Gosh, Eirikur... now you've got me asking the same as what Thomas asked...

    That's an awful lot of implicit (Reverse) and explicit conversions just to handle some negative time stamps only...

    --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 23, 2022 at 5:32 pm

    #4091300

  • Reply To: agent job with xp_cmdshell to move files

    Where is that particular "C:" drive actually located?  If it's not on the server, you'll need to us a "share" with a machine name and share name as the first...

    --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 23, 2022 at 6:40 am

    #4091069

  • Reply To: Conversion of currency stored as varchar to decimal

    jcelko212 32090 wrote:

    NO! the old Sybase MONEY datatypes have ugly rounding problems; google it! https://www.red-gate.com/hub/product-learning/sql-prompt/avoid-use-money-smallmoney-datatypes

    Agreed, but that's now how the MONEY datatype is being used in this instance.  Instead, it's being...

    --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 23, 2022 at 6:23 am

    #4091055

  • Reply To: Removing a Column

    Good question, Steve.  If you want to have some fun with two more questions, ask folks how to de-allocate the space at the page level and then how to actually...

    --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 23, 2022 at 6:09 am

    #4091051

  • Reply To: Selecting State from table based on a Begin and End Date

    jcelko212 32090 wrote:

    Simak was wrong; time is not the simplest thing. There are points in time ("high noon at the OK Coral") and maybe space,then there are durarions ("that 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)

    September 23, 2022 at 12:22 am

    #4090994

    • Viewing 15 posts - 2,701 through 2,715 (of 59,086 total)